When i go to push the button to activate my macro, it doesnt work and say i get error 1004. asks me if i want to End Debug or cancel.
here is my macro:
"Sub THE_SORT2()
'
' THE_SORT2 Macro
' Macro recorded 2007-10-24 by Paul Demchuk
'
'
Selection.SORT Key1:=Range("F3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
ActiveWorkbook.Save
End Sub"
can you see whats wrong with it? it worked like 10 seconds ago, now it mystically stopped working.
Cheers
2007-10-24
10:59:40
·
2 answers
·
asked by
That's what she said
4