WestwegoMans' Forum
Computers, Websites & Forums => MS Excel => Topic started by: WestwegoMan on Jan 23, 2015, 5:06 PM
-
To print a specific sheet
Sheets("sheet1").PrintOut
To print active sheet. (copies optional)
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Print a sheet depending on value from another sheet.
If Sheets("Sheet1").Range("M30").Value = "1" Then Sheets("sheet2").PrintOut