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
C-.
---
Flex the Geek
In Section
Tutorials