Find last row

[wpryan]

I need to find the last row of data, where the last data entry may be in different columns. I had been using this code, thinking that column B would contain the last data entry. This isn't always the case.

Please Login or Register  to view this content.

I tried modifying the LastRowCopy line to say:

Please Login or Register  to view this content.

but I get an error, Run-Time Error '1004, Application-defined or object defined error.
...anyone? Thanks in advance.

[StephenR]

You can use Find:

Please Login or Register  to view this content.

[antoka05]

Try with:

Please Login or Register  to view this content.

Regards,
Antonio

[Marcol]

Try

Please Login or Register  to view this content.

If there is no data outside Columns A:F

[wpryan]

That's fantastic, thanks Antonio.

[kapilrakh]

Last Row of a given sheet and column no....

Please Login or Register  to view this content.