Hello,
I have a macro that works in an Excel worksheet, but when copying to a google doc, it does not. I am hoping that I can get help with converting the macro to work in google docs.
Here is the macro that works in Excel.
Here is the macro in google docs that fails.Sub ConvertRunNumber() For x = 1 To 8000 RunNum = Cells(x, 1).Value Newrunnum = Left(RunNum, 8) Cells(x, 2).Value = Newrunnum Range("B2").Value = Newrunnum Cells(x, 2).NumberFormat = "0" Next x End Sub
Syntax error: SyntaxError: Unexpected identifier 'ConvertRunNumber' line: 2 file: Missing Numbers.gs





Reply With Quote