Jim's code compiles fine (i.e., no syntax error) on my Mac in XL98,
2001, v.X and 2004. What version of MacXL is your friend using?

Jim's right that the DataOption argument is not supported in VBA5, which
is what all MacXL versions use.

In article ,
Rob wrote:

thanks for the attempt Jim, much appreciated but, unfortunenlty, that did not
solve the problem only cause a "Syntax error" on the mac.

Thanks,
Rob

"Jim Cone" wrote:

Rob,

I wonder if the problem is not Windows vs. Mac but Excel version vs. Excel
version.
The "DataOption" is not available in earlier versions of Excel.
Try removing that portion of your code and giving it a try...

Selection.Sort Key1:=Range("IA3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom