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'

 

http://www.stevetaylor.org/ftp/macro_error.jpg

 

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.