Thread
: [Solved]
How to change this printing macro
View Single Post
12-01-2015, 06:47 PM
Graham Griggs
Windows 8
Office 2013
Novice
Join Date: Dec 2015
Posts: 11
Quick and dirty is thus:
Sub select_tabs_to_print()
Count = ActiveWorkbook.Sheets.Count
For nowsheet = 1 To Count
If Sheets(nowsheet).Cells(1, 1) = "PRINT" Then
'print out the worksheet
Else
'dont print out the worksheet
End If
Next nowsheet
End Sub
Graham Griggs
View Public Profile
Find all posts by Graham Griggs