Problems with Excel X on a Mac

[GaryB]

I'm trying to help msampson on a problem with rearranging data
http://www.mrexcel.com/board2/viewtopic.php?p=466331#466331

The macro is simple enough, and it runs without a problem on my PC ( XP & xl2003) but it turns out that she's running a Mac (A G5 dp with OS X, Excel X and 2004) and is getting compile errors and a syntax error on For i=1 to 100

Sub Macro3() 

Dim i As Integer 
   For i = 1 To 100 
    j = 9 * (i - 1) + 4 
   Range("A" & j, "A" & j + 7).Copy 
   Range("C" & i).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ 
        False, Transpose:=True 
    Next i 
End Sub

I've never used Excel on a Mac so I don't know if there are any syntax diferences. Does anyone know why this might be?
Many Thanks

GaryB

 

[Mark W.]

This code runs without errors on my Mac.

 

[msampson]

I tried it at home on my Mac running Excel 98 and I still got the same error??????

 

[Domenic]

I just tried running this code on my Mac using Excel X and I get the same error message.

I'm not very familiar with macros, but I understand that there's a compatibility issue between Mac and Windows based computers.

If I'm not mistaken, Mac's are still stuck using Version 5 of VBA, whereas Windows based computers are using Version 6.

 

[msampson]

Whew, I'm glad it's not just me being really dense about this then.

Any ideas anyone?
Thanks, Maureen

 

[Domenic]

Whew, I'm glad it's not just me being really dense about this then.

Any ideas anyone?
Thanks, Maureen

Try asking for help in the following newsgroup:

http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&group=microsoft.public.mac.office.excel

Hopefully someone there will be able to help you.