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

Hi Amir,

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

If you download my "Flexfind" utility, you can use it's "List" button to do
just that:

www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

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.


"Amir" wrote:

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