Hi everyone,
I found Dave Hawley's code to start the Ctrl+F find box, but I'm have a few problems. I'm trying to select all the sheets so that the find will look through them all, but when i use this code:
Sheets(Array("Active", "Inactive")).Select
Application.Dialogs(xlDialogFormulaFind).Show
the search comes up empty handed. I have no idea why. I can see they are selected, and the data im searching for i can see on the sheet.
Also, is there a way to control this find more? I would like it NOT to search a certain column, say K for example.
Thanks!
I found Dave Hawley's code to start the Ctrl+F find box, but I'm have a few problems. I'm trying to select all the sheets so that the find will look through them all, but when i use this code:
Sheets(Array("Active", "Inactive")).Select
Application.Dialogs(xlDialogFormulaFind).Show
the search comes up empty handed. I have no idea why. I can see they are selected, and the data im searching for i can see on the sheet.
Also, is there a way to control this find more? I would like it NOT to search a certain column, say K for example.
Thanks!