Simple Question on Range

Hi,

In VB, how can I determine the last row and the last column of a given Range?

For instance, if Range TEST represents cells (A1:C5),
I would like to get the 2 variable:
l_row = 5
l_column = 3

Thanks

This code should work for you:

Please Login or Register  to view this content.

Hope this helps,
theDude