Hi,
Thanks but like I said, I have done all the obvious
things.
Regards,
Robert
-----Original Message-----
Record a macro while you vary these options, and examine
the generated code.

Jerry

Bony Pony wrote:

Hi all,
I posted this before Christmas but didn't receive any
answers so I thought I'd try again.

In the EDIT, REPLACE ... / OPTIONS screen, is a little
dropdown box that tells EXCEL to search the sheet or
workbook.

I run a macro that does a find / replace of text in
the
workbook but the scope of the search is limited by
this
dropdown. In other words, I cannot seem to over rule
this manual dropdown entry via code. Is there a VB
property that is associated with this drop down box?
I've looked really hard for this and have been unable
to
locate it.

All the best and hoping for a solution,
Robert

.