Finding last non-empty cell

[machado]

Please help...

Why can't I write this:

Please Login or Register  to view this content.

like this:

Please Login or Register  to view this content.

??

Thanks

[Leith Ross]

Hello machado,

When you use Range it expects an address. When you use Cells it expects a row and column. The Cells property is returning a value to the Range object that is not an address. The two methods below are the same:

Please Login or Register  to view this content.