I get the following error messge when I run a MACRO

Run-time error 1004
Sort Method of range
Class failed

It only appears on certain machines, the macro runs ok on others.

Any ideas