Re: Ranges and Variables in Excel
Re: Ranges and Variables in Excel
- Subject: Re: Ranges and Variables in Excel
- From: Stan Cleveland <email@hidden>
- Date: Tue, 27 Nov 2007 12:02:04 -0800
- Thread-topic: Ranges and Variables in Excel
Title: Re: Ranges and Variables in Excel
On 11/27/07 11:38 AM, Justin Laden wrote:
Is there a way to use a variable in an Excel range?
If my code for the variable--finds the last row with data in a workbook--is this:
set Z to first row index of last row of used range of active sheet
Is there a way to refer to a range that includes Z?
For example:
tell range "A1: GZ"
So far I have had no luck with this.
The range specification is a string, so just concatenate the desired elements together:
tell range ("A1:G" & Z)
Stan C.
_______________________________________________
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