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