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?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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?
 

Forum statistics

Threads
1,140,936
Messages
5,703,251
Members
421,289
Latest member
fbohlandt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top