Printing all but 1st worksheet in workbook. Array. Compile error:syntax error

[dstepan]

I had this working last week and I somehow screwed up the macro.

This portion of one large macro is to printout all sheets (43 of them) except for Sheet 1. Sheet 1 is the working data file and is super huge.

When I run the code it comes up with an error "Compile Error: Syntax error" (see red highlights below).

Anyone know what could be causing this?

Sheets(Array("Sheet2", "Sheet3", "Sheet4", "Sheet5", "Sheet6", "Sheet7", "Sheet8", "Sheet9", "Sheet10", "Sheet11", "Sheet12", "Sheet13", "Sheet14", "Sheet15", "Sheet16", "Sheet17", "Sheet18", "Sheet19", "Sheet20", "Sheet21", "Sheet22", "Sheet23", "Sheet24", "Sheet25", "Sheet26", "Sheet27", "Sheet28", "Sheet29", "Sheet30", "Sheet31", "Sheet32", "Sheet33", "Sheet34", "Sheet35", "Sheet36", "Sheet37", "Sheet38", "Sheet39", "Sheet40", "Sheet41", "Sheet42", "Sheet43", "Sheet44",)).PrintOut , , 1    Sheet1.PrintOut , , 1 'use this method to print all together at the end instead printing individually.
    Application.ScreenUpdating = True
        End With
        End Sub

 

[Michael M]

Remove the comma after "Sheet44" !!!

 

[dstepan]

Aah haa - thanks a million. It now works.