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.

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

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


On Nov 23, 11:30*am, Dave Peterson wrote:
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

I should have mentioned this before...

You may want to try Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/


wal wrote:

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

On Nov 23, 11:30 am, Dave Peterson wrote:
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

--

Dave Peterson