I am utilizing the "Replace" function in a macro with the following code:
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.Please Login or Register to view this content.
Any idea the syntax for this?
Thanks a lot -
Bookmarks