Thank you for ur fast and detailed reply



"Jim" wrote in message
...
I need to know the address of the last cell (non-empty) on my worksheet. I
see that .Rows.Count and .Columns.Count seem to show only the max
size. "Last" is defined as a non-empty cell with the largest row and
column address.

thanks