Re: Filling a cell in Excel
Re: Filling a cell in Excel
- Subject: Re: Filling a cell in Excel
- From: "Rebecca O'Connell" <email@hidden>
- Date: Fri, 28 May 2004 10:40:38 -0400
For the first line I got "Can't set..."
For the second line I got missing value for z
Turns out the correct answer is...
tell application "Microsoft Excel"
set value of selection to "asdfg"
set x to value of selection
end tell
Note: If you have one cell selected, that one cell will be set to "asdfg"
and x will be "asdfg". If you have two cells selected, both cells selected
will be set to "asdfg" and x will be {{"asdfg", "asdfg"}}.
It wasn't working before because I needed to restart Smile and/or Excel.
Thanks your help,
Rebecca
On 5/27/04 10:50 PM, "trinko" <email@hidden> wrote:
>
set the value of the first cell in the selection of window 1 to 19
>
set z to the value of the first cell in the selection of window 1
Sent using the Microsoft Entourage 2004 for Mac Test Drive.
_______________________________________________
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.