Last Cell in row + 1

[mpeplow]

This works great for the finding the last cell with data

Please Login or Register  to view this content.

This works better

Please Login or Register  to view this content.

But I want something like this

Please Login or Register  to view this content.

Anyone know how to do this?

[mpeplow]

Nevermind, I spoke too soon.

Please Login or Register  to view this content.

That should work.

Thanks.

[mikerickson]

This works even in 2007 with more than 256 columns

Please Login or Register  to view this content.