search for a value in a range

[RoseGuy]

Is there a way to search for a value that's in between a range of numbers and have it find the correct cell. For instance,

I want to be able to search for 51477 and have it highlight Column A4.

 

[smozgur]

@RoseGuy: Thanks for marking the solution, but you marked my post instead of the actual answer. Next time, please click on the checkmark button right next to the post that answers your question. It is post#2 in this question.

I just changed the marked solution, so there is no further action necessary for this question.

Also, I can see that you received the answer here for the other question you asked here and also posted as a duplicate thread. Therefore, I just closed your new question to avoid duplication.

Copy to active cell after user input

My VBA code makes a cell active after manual user input in cell C2. Works great. I would like to now copy that input into the cell where the cursor is. That would be simple except the input and the active cell changes with every user input. Is there code to say whatever cell is active, copy and...

www.mrexcel.com

 

[RoseGuy]

Thank you. Sorry. New job and new to the forum!

 

[smozgur]

Thank you. Sorry. New job and new to the forum!

I just wanted to inform you about your other question since I figured that you got the answer here. No need to be sorry.

Congratulations on the new job!