I've browsed through several examples I've found here and even tried playing with a bit of code to solve this problem, but failed miserably. Any help that can be provided would be greatly appreciated.
I've got a macro that reads a text file into a single column with range "A1:A10000" in worksheet "Source" that lives within the workbook containing this macro. I'd like to be able to search that worksheet for the cell that contains a particular text string, say " Excel", and have the macro return the address of the cell that contains it. I've tried using the .Find property but I only seem to be getting the value that I'm searching for instead of the cell address. Clues?