Re: Ranges and Variables in Excel
Re: Ranges and Variables in Excel
- Subject: Re: Ranges and Variables in Excel
- From: Larry McMunn <email@hidden>
- Date: Tue, 27 Nov 2007 15:58:27 -0500
On Nov 27, 2007, at 3:01 PM, "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.
Thanks for the help.
Justin, I use something like this:
set targetRange to ("A1:G" & Z)
tell range (range targetRange)
------------------------------------------------------------
Happy Automation!
Larry McMunn
President
McMunn Associates, Inc.
Collingswood, NJ
Seminole, FL
Mobile: (856) 261-7018
Main Office: (856) 671-6067
Seminole, FL: (727) 392-6509
FAX: (866) 636-4446
AppleScript Pro Florida, Feb 2008
http://scriptingmatters.com/aspro
_______________________________________________
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