Macro problem

Spleen

New Member
Joined
Oct 4, 2006
Messages
4
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?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Spleen

New Member
Joined
Oct 4, 2006
Messages
4
Good question, i didnt even know that would be an issue ( to think I have a IT degree ) :oops:

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?
 

Spleen

New Member
Joined
Oct 4, 2006
Messages
4
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

New Member
Joined
Oct 4, 2006
Messages
4
Sub Auto_Open()
'
' Auto_Open 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?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,845
Messages
5,544,628
Members
410,626
Latest member
rkmadasu
Top