Re: How to add a "tab" in Excel
Re: How to add a "tab" in Excel
- Subject: Re: How to add a "tab" in Excel
- From: Bill Metzinger <email@hidden>
- Date: Thu, 12 Feb 2004 09:34:10 -0500
On Feb 12, 2004, at 1:00 AM, Tom wrote:
How do I program applescript to change to a cell relative to the first
active cell, rather than referring to an absolute position in the
spreadsheet?
Get the row and column of the active cell and go from there.
tell application "Microsoft Excel"
Activate
repeat 5 times
set r to Row of (ActiveCell)
set c to Column of (ActiveCell)
set r to r + 1
set c to c + 1
Select Range ("R" & r & "C" & c)
end repeat
end tell
Bill
} Where'd you get the coconuts?
} We found them.
} Found them? In Mercea? The coconut's tropical!
} What do you mean?
} Well, this is a temperate zone.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.