is there a way to export the results of the 'find' query to a notepad or a
new excel sheet)
is there a way to export the results of the 'find' query to a notepad or a
new excel sheet)
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)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks