Educational Software Thread, Excel Macro - Edexcel GCE Exams in Technical; Is anybody else running the Edexcel GCE tests?
We have been sent the pre-release files, a word doc, excel spreadsheet ...
16th May 2006, 03:49 PM #1
Excel Macro - Edexcel GCE Exams
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.
' 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 _
IDG Tech News
By Vegas in forum How do you do....it?
Last Post: 18th December 2007, 08:32 PM
By callumtuckey in forum General Chat
Last Post: 22nd May 2007, 03:45 PM
By oyoung in forum Windows
Last Post: 30th March 2007, 11:27 AM
By randle in forum Windows
Last Post: 9th February 2007, 10:32 AM
Last Post: 4th October 2005, 09:59 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)