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
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