Re:Excel: finding last used cell in a range
Re:Excel: finding last used cell in a range
- Subject: Re:Excel: finding last used cell in a range
- From: Raymond P Reedy <email@hidden>
- Date: Mon, 2 Feb 2009 15:48:08 -0500
On Feb 2, 2009, at 1:54:55 , Justin Laden <email@hidden> wrote:
I had a line in some of my scripts that I thought gave me the last
used row in a range--and I mean the last cell with data inside.
set endRow to first row index of last row of used range of active
sheet
But I don't think it is working.
I tried Paul's code from the VBA transition guide, and I couldn't get
it to compile--any ideas?
Justin,
I had to use this code...
-- How many rows?
set lastRowNum to first row index of (get end (cell 1 of row (count
rows)) direction toward the top)
Ray
Raymond P Reedy
email@hidden
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