Re: Scripting Excel to go to the next row
Re: Scripting Excel to go to the next row
- Subject: Re: Scripting Excel to go to the next row
- From: Craig Treleaven <email@hidden>
- Date: Wed, 23 Oct 2002 21:13:09 -0400
At 4:37 AM -0400 2002/10/23, David Wignall wrote:
>
on 23/10/2002 8:30 PM, Anthony Couche at email@hidden
>
wrote:
>
>
> I am looking for the correct syntax to get Excel to select the cell
>
> immediately below the currently selected cell.
>
>
Select the (Offset RowOffset 1) of ActiveCell
>
>
--
>
Dave
And you don't have to select, then paste. Just set the values directly, ala...
tell application "Microsoft Excel"
set myVar to "BlahBlahBlah"
set myCell to (ActiveCell Offset RowOffset 1)
set Value of myCell to myVar
set Value of Range "R2C2" to myVar
end tell
Craig
Craig Treleaven, CA -- Clearview Consulting
(905) 829-2054 email@hidden
_______________________________________________
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.