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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
