Link to home
Start Free TrialLog in
Avatar of Jagwarman
Jagwarman

asked on

Find last used cell in column A

This should be so simple but it's not.

I just need to find last used cell in column A

I have looked at other solution in EE but none of them seem to work for me.

Thanks
Avatar of regmigrant
regmigrant
Flag of United Kingdom of Great Britain and Northern Ireland image

you can use :

LastRow = Range("A1048576").End(xlUp).Row

But I would guess that you have tried that if you searched EE, can you post a sample and say what isn't working?
Avatar of Jagwarman
Jagwarman

ASKER

It does not actually select the cell
ASKER CERTIFIED SOLUTION
Avatar of regmigrant
regmigrant
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent thanks