View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rob
 
Posts: n/a
Default Office 2003 and mac office

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

Jim Cone
San Francisco, USA


"Rob"
wrote in message

I have a workbook with some macros and such that i made on my XP computer. I
sent it to a friend of mine to use, but he has a mac. The macro i made to
sort runs into a problem when he runs it, however when he sent me the
workbook and i ran the macor it worked fine. It had a 1004 runtime error.
Is this a common problem due to it being made on a pc and ran on a mac? what
changes need to be made to make it work on a mac?

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

is what was highlighted.

thanks,
Rob