find last row in excel
find last row in excel
- Subject: find last row in excel
- From: Robert Poland <email@hidden>
- Date: Sun, 31 Jul 2005 11:10:10 -0600
Hi,
I wish to find the last row of data in an excel
spreadsheet. This works, but take too much time.
Isn't there a command that will do the same thing?
set readRow to 1000
tell application "Microsoft Excel"
Activate
Select Worksheet "Averages"
set readCell to "$C$" & readRow
set x to Value of Cell readCell
repeat while x 0
set y to x
set readCell to "$C$" & readRow
set x to Value of Cell readCell
set readRow to readRow + 1
end repeat
end tell
set y to y as integer
y
Tia,
--
Bob Poland - Fort Collins, CO
http://www.ibrb.org/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden