Macro problem

[Spleen]

Hiya fellas, got a little problem with a macro ive set up.

I recorded a new macro to sort data in a table, i assigned this to a button. It all works fine for me. I sent it to a mate of mine for a test and it worked fine for him aswell.

I sent it to the person who needs the excel file ( he runs a local pool league) and I explained to him to enable macros etc etc but he says when he runs it he gets runtime error 1004, does anyone have the faintest idea why?

 

[SteveO59L]

Are the two Excel versions compatible ?

 

[Spleen]

Good question, i didnt even know that would be an issue ( to think I have a IT degree )

Ill email him and see what he says, but is there anything else it could be that I can suggest to him to try aswell?

 

[SteveO59L]

Try posting the code you have, and which line it fails.

 

[Spleen]

OK mate will do , he's not around at the moment so it will be later on tonight, strange that ity fails for him but not for me or my other friend. I woudlve thought that there couldnt be a problem with the code if it works for all but not him?

 

[Spleen]

Sub Autpen()
'
' Autpen Macro
' Macro recorded 04/10/2006 by Spleen
'

'
Selection.Sort Key1:=Range("I2"), Order1:=xlDescending, Key2:=Range("C2") _
, Order2:=xlDescending, Key3:=Range("G2"), Order3:=xlAscending, Header _
:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom _
, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
xlSortNormal
Range("D26").Select
End Sub


Thats the code thats not working, says something about sort method of range class failed?