I am utilizing the "Replace" function in a macro with the following code:

Please Login or Register  to view this content.
However, I want to be able to specify only the search and replace with "Sheet" rather than "Workbook". As of now, I have to remember to go in and select "Sheet" before running the macro.

Any idea the syntax for this?

Thanks a lot -