I didn't explain that right. Cell C24 is a number on the active sheet, but the sheet to be printed is a seperate worksheet. I am very proud to say that with your help I fixed it myself using the following:


Private Sub CommandButton3_Click()
    Sheets("Business Unit - Questions").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=Range("c24"), Collate:=True
End Sub
Worked like a charm. Thanks for all your help!