find and replace within workbook macro
 

Excel 2003 has the ability to search within a workbook or worksheet. If you
have the 'within workbook' option selected, is there a way to change that in
a macro?

find and replace within workbook macro
 

I don't think so.

Maybe you could screw around with Sendkeys?????



CVL wrote:

Excel 2003 has the ability to search within a workbook or worksheet. If you
have the 'within workbook' option selected, is there a way to change that in
a macro?

--

Dave Peterson