LastCell Function

[pmguerra]

Hi!

I'm trying to write a simple function to determine the last cell (or row) of any worksheet.

I thought it would be simple but the following code presents erroneous results:

Please Login or Register  to view this content.

The Debug.Print returns the correct value. However, in the worksheet, I get "1" when this isn't definitely the case!

When replacing ".Row" for ".Address", same wrong value. In this case "$1:$65536". Once again, the debug.print returns the correct value...

Any hints?

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[pmguerra]

Thank you!

That works fine! But I still don't understand why my code won't work...

Thank you oncea again!