View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wal wal is offline
external usenet poster
 
Posts: 19
Default 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.