Hello all, could use some help here...
I have an Excel workbook with 10 tabs or so. One tab is a "Print" worksheet. On this worksheet, I have created two buttons in VB -one is "Print Results Only", and the other is "Print Questionaire and Results." The latter is giving me trouble...
Private Sub CommandButton2_Click()
Sheets(Array("X-Ray Assessment", "ERM Framework", "Operational Risks", "Strategic Risks", "People Risks", "Market Risks", "Financial Risks", "Business Unit - Questions", "Business Unit - Score")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
Can anyone point out the problem?! I am getting an error that says "Runtime error (9) ... Subscript out of range." All of the names are an exact match, so i can't figure out the problem.
Bookmarks