Hi, I have a spreadsheet with a stock list. Each item has an individual number.
I have a code below, which I have doctored from other various sources (thanks to them). The problem I have is that if I search for number '12' the spreadsheet highlights every cell with 12 in (120 121 122 123 etc...)
Is there any way I can change the code so that it returns only the 12 and not every cell that contains 12? Any help from you VBA / Excel guru's will be very much appreciated.
The current code is as follows:
Bookmarks