List out the "Find All" results list?

  • Thread starter Thread starter wal
  • Start date Start date
W

wal

Excel 2003

Is there a way to "capture" programatically the list of values that
results when you use the "Find All" button in the Find dialog? The
desired values are spread all over the worksheet pretty much at
random. I would like to reproduce the values (or, if necessary, the
Book/Sheet/Name/Cell/Value/Formulas) in a simple list or table on a
separate worksheet, in the order shown in the Find All results dialog.

Thanks.
 
Nope, excel doesn't expose that "find all" to VBA.

But you could just repeat the find until you find the first one. Take a look at
FindNext in VBA's help.
 
Thanks. I used the suggested sample macro as the basis for what I
needed to do, and it works fine.
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Find the correct sheet then find a value on that sheet 8
Find a value in a sheet and replace it with another value if it matches 8
If value occurs more than once then delete all of them 8
CSE with function returning an array? 2
Filter Records based on the value selected from a drop-down list b 3
help with listing data 12
Validation List 1
Copy adjacent Sheet and name from a list 42

Back
Top