Re: Questions about scripting MS Excel v.X
Re: Questions about scripting MS Excel v.X
- Subject: Re: Questions about scripting MS Excel v.X
- From: Paul Berkowitz <email@hidden>
- Date: Wed, 03 Jul 2002 08:36:42 +0200
On 7/3/02 8:25 AM, "mike lee" <email@hidden> wrote:
>
set rangetotal to 0
>
repeat with x from 19 to 42
>
set rangetotal to rangetotal to (get Value of Cell "RxC2")
>
end repeat
>
____
>
>
This doesn't seem to be working and the Excel documentation for AS is
>
difficult to parse.
It's got absolutely nothing to do with Excel. Your variable x represents
string integers between "1" and "19". But you've included the character "x",
not the variable x, in the string "RxC2". This is basic scripting. What you
want there is:
set rangetotal to rangetotal to (get Value of Cell ("R" & x & "C2"))
That will do it.
--
Paul Berkowitz
_______________________________________________
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.