Excel Macro - Edexcel GCE Exams

[steve]

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?

Sub SortDates()
'
' SortDates Macro
' Macro recorded 04/14/2005 by trevor.xxxxxx(edit)
'

'
Range("A8:E18").Select
Selection.Sort Key1:=Range("E8"), Order1:=xlAscending, Key2:=Range("B8") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _
:=xlSortNormal
End Sub

This only happens on Excel 2000, works fine on Excel 2003.