Number of rows in xls file

[Gerry Metze]

I'm trying to automate processing of an .xls file. Are
there variables/parameters/whatever I can read that tell
me how many rows and columns there are in the .xls file?
The file has several blank lines interspersed, so looking
for blank lines isn't enough.

 

[Ron de Bruin]

Hi Gerry

Am I correct that you want to know how many rows have data on you sheet?
Or do you want to know the last used row/column on your sheet

 

[Guest]

Hi Ron --

Yes; I can't look for empty rows to stop a reading loop
because there are embedded empty rows in the file.

I want to read the data into a VB array for further
processing.

Thanks,
Gerry

-----Original Message-----
Hi Gerry

Am I correct that you want to know how many rows have data on you sheet?
Or do you want to know the last used row/column on your sheet

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Gerry Metze" <[email protected]>

wrote in message [email protected]...

 

[Gerry Metze]

Thanks a lot, Bill! It works like a charm. I also used
c = Selection.Column to read just the cells that were
filled. A lot better than filling a 65536x256 array with
mostly empty cells.