Find the last non-empty cell in each row and last non-empty row?

Jan 17, 2013 at 8:36 PM
Edited Jan 17, 2013 at 8:36 PM

Hi,

I need to process Excel sheets of rather "fluid" format.

Specifically, I need to be able to find last non-empty row in a sheet as well as last non-empty cell in each row.

Any idea how to get this in non-iterative manner?

Thanks ahead!

Jan 17, 2013 at 10:55 PM

listWorkSheetInfo() function returns just this type of information. At least I think it did the last time checked.

- Christopher Mullins