Apple

set theLastRow to first row index of (last cell of used range)

gives a convenient upper bound for the cells to look at, this is a useful information I wasn't aware of.

Am 21.08.2013 um 14:02 schrieb Willard L. McMunn:

Try this:

tell application "Microsoft Excel"
tell active workbook
tell active sheet
set theLastRow to first row index of (last cell of used range)
tell range ("A1:A" & theLastRow)
set theResult to string value of every cell
repeat with jItem from 1 to count theResult
if item jItem of theResult = "" then
set item jItem of theResult to false
end if
end repeat
set theResult to strings of theResult
end tell
end tell
end tell
end tell

References:
	>Re: AS and Excel (From: "Willard L. McMunn" <email@hidden>)