Vba Cellsfind Xlwhole. Excel VBA FIND Function (& how to handle if value NOT found). Find is a very powerful option in Excel and is very useful.
Together with the Offset function you can also change cells around the found cell. Excel VBA FIND Function (& how to handle if value NOT found). The Find method of the Range object is bit tricky to work with until you understand how it works.
The other option is xlWhole, which would try.
Find Method in your VBA code.
Excel VBA FIND Function (& how to handle if value NOT found). If you'd like to follow along, enter the data into xlWhole - Requires the entire cell to match the search value. xlPart - Searches within a cell for the search string. Together with the Offset function you can also change cells around the found cell.