Re: Excel last cell
Re: Excel last cell
- Subject: Re: Excel last cell
- From: nellA hciR <email@hidden>
- Date: Wed, 13 Dec 2000 08:19:35 -0900
tell application "Microsoft Excel"
activate
+event miscdosc; "SELECT.SPECIAL(11)"
end tell
-- hcir
>
I am having problems getting the last cell of a large imported text file in
>
Excel (by large I mean roughly 1000 rows by 18 columns so not massive). I
>
found this script below by Carol Ellis dated Mon, 12 Apr 1999 on the archives
>
which works fine on my text files as long as they are below 300 rows. With
>
anything larger i get an error saying "unable to get length of 0". I presume
>
that the line "set theSelection to FormulaR1C1 of theRange" is unable to
>
process the large amount of data and just returns "0". Is there any other way
>
to get the number of used rows as I can't seem to find one and I'm getting
>
quite frustrated now. The Text file is a log report from a Splash RIP that I
>
am trying to filter out data into a new excel sheet. Also what exactly is the
>
definition of the FormulaR1C1 property as I can't find any documentation on
>
the Excel dictionary.