Search and move to cell macro

[ocm]

Hi,

would anyone know a script to do a search in the complete workbook (5 workseet within), find what i'm looking for and then move to the cell containing the data.

Eg. worksheet 1 search "abc", abc is located in worksheet 3 cell f11.

The search will find my text and then move me straight to the cell containing that information.


Thanks

[Leith Ross]

Hello ocm,

Welcome to the Forum!

This macro will prompt you for the text you want to find. After you enter the text you will asked if you want to match the whole word or not. All worksheets in the workbook are searched. If the text is found, the cell is selected.

Please Login or Register  to view this content.

[ocm]

Thank for the quick reply and welcoming me to the forum.

I tried the code you provided and every search i lookup i get a error. I slighty modified the code to prompt me with an error msg if the search finds nothing.

I created a button in the worksheet where i know the data is located and still i get an error stating the data cannot be found.

Any ideas

[Leith Ross]

Hello ocm,

To troubleshoot the problem, you will need to post your workbook.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.