Find last used cell in column A

Jagwarman
Jagwarman used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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?

Author

Commented:
It does not actually select the cell
add
range("a"& LastRow).select

Author

Commented:
Excellent thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial