Re: Setting a range using a variable
Re: Setting a range using a variable
- Subject: Re: Setting a range using a variable
- From: Paul Berkowitz <email@hidden>
- Date: Sat, 29 Mar 2008 10:44:16 -0700
- Thread-topic: Setting a range using a variable
Title: Re: Setting a range using a variable
On 3/29/08 9:14 AM, "Ed Stockly" <email@hidden> wrote:
sort range ("C & i : J" & i)
This is how I would specify a range in Excel:
range ("C" & i & ":" & "C" & i)
Save some typing (and the OP's example for the second column was "J"):
range ("C" & i & ":J" & i )
as Stan said. Of course Raymond somehow expected everyone to know he was scripting Excel, though he never said so. Luckily, everyone knew.
--
Paul Berkowitz
_______________________________________________
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