Hello there,
The below code should work for you:
To insert the code into your workbook
1.Press Alt+F8 on your keyboard
2.Clear the macro name box and type LocateCells in the blank box provided
3.Select the Create option
4.In between the Sub LocateCells() and End Sub copy and paste the code I have provided above. (anything that appears in green is a comment that I left for you to help you understand)
5.Exit out of the Visual Basic Window
6. Select the workshee that contains the data and Press Alt+F8 again and this time select the LocateCells macro
7.Select Run
Let me know if this works for you.
Bookmarks