Hello,

This is something so simple but is causing me a tremendous amount of frustration regardless...

I need a macro that basically replaces the native "Find" function in Excel. The intention is to:

1) Have the user type in a word in cell A1
2) Click on a "Find" button
3) Macro runs and searches the worksheet to find the word in cell A1. Once the word is found, the macro will bring the user to the cell that the word in cell A1 is in.

Thank you for your help.