I want to be able to incorporate the Excel FIND command into a VBA subroutine so as to be able to find (but not replace) all instances of a user-specified text value in whatever area of a workbook that I select. The values in all cells of the workbook are text - words or phrases; what I am searching for are complete cell values. I then want to display all the matching cells and their addresses.

The obvious way to get started is to record a macro of running the Excel command. But I have tried to do this several times in different ways and always failed . When I go to edit the completely-recorded macro, I find that it has the expected headers and footers but no code!

Can anyone explain why this is and how it can be avoided/corrected? If it cannot, what is the basic VBA code for searching a range and returning all the matching values?