J
jfb
Hi,
I've been writing some simpe menus/macros in XL2002 but when I try to run
them in XL 97 it complains with runtime error 1004.
I only want to sort a spreadsheet by a given column and use the in-built
form feature for Data entry,
Here is a section of code.
Private Sub CommandButton3_Click()
Worksheets("Data").Range("A1:AZ5000").Sort _
Key1:=Worksheets("Data").Columns("P"), _
Header:=xlGuess
Worksheets("MainMenu").Activate
Worksheets("Data").ShowDataForm
Worksheets("Data").Range("A1:AZ5000").Sort _
Key1:=Worksheets("Data").Columns("H"), _
Header:=xlGuess
End Sub
It also complains about the range but I reckon I know how to fix that.
Any help is appreciated.
Thanks
JB
I've been writing some simpe menus/macros in XL2002 but when I try to run
them in XL 97 it complains with runtime error 1004.
I only want to sort a spreadsheet by a given column and use the in-built
form feature for Data entry,
Here is a section of code.
Private Sub CommandButton3_Click()
Worksheets("Data").Range("A1:AZ5000").Sort _
Key1:=Worksheets("Data").Columns("P"), _
Header:=xlGuess
Worksheets("MainMenu").Activate
Worksheets("Data").ShowDataForm
Worksheets("Data").Range("A1:AZ5000").Sort _
Key1:=Worksheets("Data").Columns("H"), _
Header:=xlGuess
End Sub
It also complains about the range but I reckon I know how to fix that.
Any help is appreciated.
Thanks
JB