List out the "Find All" results list?
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.
wal wrote:
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.
--
Dave Peterson
|