Hello all,
I have a small macro that helps the user search a database of food items for a calorie diary. This is my problem: it works fine for my machine at home running Excel 2000, but hangs with an error message (Run time error 1004) on my computer at work running Excel 2002.
This is the code:
Private Sub SearchFDbase1_Click()
Worksheets("Food Database").Activate
Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show
End Sub
Ironically, if I remove the "Cells.Select" line, it runs fine on Excel 2002. Should I use "On Error Resume Next"?
As an aside, when I run the macro in Excel 2000 without the "Cells.Select" it runs, but the "Find" form is unable to search the database sheet.
Thanks in advance.
Tom.
I have a small macro that helps the user search a database of food items for a calorie diary. This is my problem: it works fine for my machine at home running Excel 2000, but hangs with an error message (Run time error 1004) on my computer at work running Excel 2002.
This is the code:
Private Sub SearchFDbase1_Click()
Worksheets("Food Database").Activate
Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show
End Sub
Ironically, if I remove the "Cells.Select" line, it runs fine on Excel 2002. Should I use "On Error Resume Next"?
As an aside, when I run the macro in Excel 2000 without the "Cells.Select" it runs, but the "Find" form is unable to search the database sheet.
Thanks in advance.
Tom.