Find and display (go to) exact values (Macro)

[Soilwork]

Hi there,

I want to create a macro, that looks for a specific value in a column

For example

Sheet1, cell A:1 is the cell where you enter the search data

Column B is a column wheres the data taken (values are stored)


what i want to get is when you type "xyz123" in cell A:1 and hit the Control button for macro next to it, it checks entire column B for exact match of "xyz123" value

If value find then this cell must be selected.

[Greg M]

Hi there,

Try using the following code which should be entered in a standard VBA CodeModule:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Soilwork]

Thank you very much, will test this soon. Also will post the result here.

[Alf]

A slightly different approach in solving your problem.

Please Login or Register  to view this content.

Alf

[Soilwork]

Alf,

Brilliant! Exactly what i needed. Simple and sharp as a katana sword.
You're really a forum expert!

[Alf]

You are welcome.

Thanks for feed back and rep.

Alf