Need help with a search macro!!!!!!

  • Thread starter Thread starter 98hgurney
  • Start date Start date
9

98hgurney

Please help i need to design a macro which will enable the Find box t
come up and i can search the workbook for whatever
need???!!!:confused
 
If you're using xl2k, then select your worksheets first and do a ctrl-A to
select all the cells on each sheet.

Then Ron's display of the dialog will work nicely.

If you're using xl2002(+), then this is built into the find dialog. (Under
Options: "within" workbook.)

If you're using xl97 (but works with any version, actually), then instead of
building one yourself, you can use Jan Karel Pieterse's FlexFind:

http://www.bmsltd.ie/MVP/
 
Something like this

Sub MultiFind()
Worksheets.Select
cells.select
Application.Dialogs(xlDialogFormulaFind).Show
cells(1).select
ActiveSheet.Select
End Sub
 
Back
Top