Where to put results of the "find" function.
 

in EXCEL 2002 during the very first use of "find" one is asked what to
do with the results of the find. Either to copy to another location in the
worksheet, or list at the bottom of the find window. The dialog box does
not open again on subsequent uses of "find". How does one get back to that
dialog box, or is there another way to change where the results of a "find"
are placed after the initial pass?

Where to put results of the "find" function.
 

To place the results you need a formula or a macro using FIND. Look in the
help index.
--
Don Guillett
SalesAid Software

"DEP" wrote in message
...
in EXCEL 2002 during the very first use of "find" one is asked what to
do with the results of the find. Either to copy to another location in
the
worksheet, or list at the bottom of the find window. The dialog box does
not open again on subsequent uses of "find". How does one get back to
that
dialog box, or is there another way to change where the results of a
"find"
are placed after the initial pass?

Where to put results of the "find" function.
 

You won't get any different answers than the last bunch you received on Nov.
14th and 16th.


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 14:01:02 -0800, DEP wrote:

in EXCEL 2002 during the very first use of "find" one is asked what to
do with the results of the find. Either to copy to another location in the
worksheet, or list at the bottom of the find window. The dialog box does
not open again on subsequent uses of "find". How does one get back to that
dialog box, or is there another way to change where the results of a "find"
are placed after the initial pass?