Is anybody else running the Edexcel GCE tests?
We have been sent the pre-release files, a word doc, excel spreadsheet and a text file.
When trying to run the marco in the excel spreadsheet we get a run-time error '1004'
I'm no macro guru, so can anyone see if there is a problem?
This only happens on Excel 2000, works fine on Excel 2003.Sub SortDates()
' SortDates Macro
' Macro recorded 04/14/2005 by trevor.xxxxxx(edit)
Selection.Sort Key1:=Range("E8"), Order1:=xlAscending, Key2:=Range("B8") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _
There are currently 1 users browsing this thread. (0 members and 1 guests)