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: Walter Ian Kaye <email@hidden>
- Date: Wed, 11 Feb 2004 22:01:51 -0800
At 12:19a -0500 02/12/2004, email@hidden didst inscribe upon an
electronic papyrus:
I am beginning to learn applescript and have just recorded my first script in
Excel. I am attempting to type text into adjacent cells. When I record the
script, it begins by selecting the "active cell". Then, when I tab to the next
cell to the right, the reference is to a specific cell in the
spreadsheet, as a row and column, not as for instance "tab to the
next cell to the right." 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?
Change the reference from "RyCx" to "RC[1]".
Eventually, I may want to navigate up or down, to the left or right
of any given cell where I am working.
Up 1: R[-1]C
Down 1: R[1]C
Left 1: RC[-1]
Right 1: RC[1]
See basic Excel docs about addressing cells.
-boo
_______________________________________________
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.