copy find-paste

Hello,

I would like to create macro, where it would on macro run copy text from active cell and find that value in another sheet (in column H) and select that cell.

What I did is this:

Please Login or Register  to view this content.

But this results in empty cell in the last non empty row in column A

Thanks for help,
Vito.

This is a bit crude but should do what you want. Note it will error if more than one cell is selected

Please Login or Register  to view this content.

This will do what you want

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save