List out the "Find All" results list?
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.
|