in reply to Last cell?
in thread Using Win32::OLE and Excel - Tips and Tricks

Upon further investigation, I have found that this is not reliable if the columnar data is not of equal row size. It returns the last row of the right most column, which is incorrect in some cases.

The methods I used in the examples return the last row (over all) and the last column (over all) vs finding the location of the last cell in the last column

So, if the data on the worksheet is symmetric, your function works faster, however yours would not be reliable to, say, put edges around all the cells in a data set that has columns of different row sizes


Flex the Geek