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
|