Syntax error: SyntaxError: Unexpected identifier 'Macro1' line: 1 file: macros.gs

18 views
Skip to first unread message

Google Apps Script Community

unread,
Sep 18, 2023, 4:41:09 PMSep 18
to Google Apps Script Community
Sub Macro1()

'Macro1 Macro

'
Range("F4:F19").Select
Selection.Copy
Sheets("CUSTOMER DETAIL").Select
Range("Q1").Select
Selection.End(xlDown).Select
Selection.End(xlToLeft).Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Sheets("invoice template").Select
Application.CutCopyMode = False
Selection.ClearContents
MsgBox "DATA SAVED"
   
End Sub



this is my macro as per excel sheet please help me
Reply all
Reply to author
Forward
0 new messages