Vba Excel code gives me Compile Error, Expected: List Separator or ) on my Mac

[cfreeman]

Here is the code I used which I got from MrExcel Youtube video for the macro NextInvoice. I keep getting this error

Compile Error, Expected: List Separator or )

It highlights the colon as the problem. I'm using Excel 2011 for Mac

Sub NextInvoice()
Range(“F4”).Value = Range(“F4”).Value + 1
Range(“A21:F36”).ClearContents
End Sub

 

[Norie]

You seem to have strange quote characters, “ should be ".

 

[cfreeman]

It's the only quote character on my keyboard, Shift key and " next to the return key

 

[cfreeman]

it's the only quote character on my keyboard, Shift key and (" ") key next to the return key

 

[Norie]

If you copy and paste the code below does it work?

Sub NextInvoice()
    Range("F4").Value = Range(“F4”).Value + 1
    Range("A21:F36").ClearContents
End Sub

 

[cfreeman]

I've copied and pasted and I don't get that error code anymore but now I'm getting a new one;

Sub NextInvoice() is highlighted and the error message say undifined variable

 

[cfreeman]

When I assign it to the shape and click on the lightning bolt now I just get 400 Microsoft Visual Basic. Very strange