Nice technique jmhultin. I would certainly use something like this except all the workbooks I deal with have so many rows and columns of data that the find all would return 500 + results. and then I would not be able to select anything else on my worksheet until I found what I was looking for. I did not intend for my solution to be difficult. A lot of people will actually try to make you code it yourself but I will write it for you so you can just copy and paste it.

It is an extremely simple process to use any code after it is written.

Complete these steps.
Complete these steps.
1. open your workbook (until you are comfortable editing in the VBA editor you should only have 1 workbook open)
2. Press Alt + F11 to open up the editor.
3. On the Menu click Insert>Module
4. In the new module that comes up, copy and paste the entire code from Sub to End Sub
5. Close the VBA editor or run the code from the editor by pressing the play button while your text cursor is somewhere in the code. Again be sure your workbook is backed up before running because you cannot undo a macro.

Let me know how that works out if you have a lot of data to go through I'm sure this will be a real help.