Hi

I have a macro which opens up the "find and replace" window: -


Application.SendKeys "^f"

I want to know if it is possible to modify this macro or use another one that will automatically search for text/ numbers anywhere in the workbook rather than just the sheet that is being viewed, without the user having to manually select workbook from the drop down menu under the options.

Thanks for your help