List out the "Find All" results list?

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.
 
D

Dave Peterson

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.
 
W

wal

Thanks. I used the suggested sample macro as the basis for what I
needed to do, and it works fine.
 
Top