export find results

A

Amir

is there a way to export the results of the 'find' query to a notepad or a
new excel sheet)
 
D

Duke Carey

I expect that the only way to do that would be through VBA. If you press
Alt-F11 from Excel you'll go to the VBA editor. Go to Help and look up the
Find method and view the topic as it relates to a Range object. There is
example code included that cycles through every instance that Find locates.
You could cobble that code together with some other code to write the results
to a text file.
 
Top