Setting a range using a variable
Setting a range using a variable
- Subject: Setting a range using a variable
- From: Raymond P Reedy <email@hidden>
- Date: Fri, 28 Mar 2008 17:35:08 -0400
I have the following snippet of code in a script...
set rng to (range "C6:C330")
repeat with i from 6 to 330
sort range ("C & i : J" & i) of worksheet "Sheet3" key1
(range "c & i" of worksheet "Sheet3") ¬
order1 sort descending orientation sort columns
end repeat
At runtime the range is calculated as..
"C & i : J6" and the sort fails.
How do I get the range to calc as "C6 : J6"
Thanks,
Ray
Raymond P Reedy
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden