WestwegoMans' Forum

Computers, Websites & Forums => MS Excel => Topic started by: WestwegoMan on Jan 23, 2015, 5:06 PM

Title: Macro to print sheet
Post by: WestwegoMan on Jan 23, 2015, 5:06 PM
To print a specific sheet

Code: [Select]
Sheets("sheet1").PrintOut
To print active sheet. (copies optional)

Code: [Select]
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Print a sheet depending on value from another sheet.

Code: [Select]
If Sheets("Sheet1").Range("M30").Value = "1" Then Sheets("sheet2").PrintOut
SimplePortal 2.3.6 © 2008-2014, SimplePortal