View Single Post
 
Old 12-01-2015, 06:47 PM
Graham Griggs Graham Griggs is offline Windows 8 Office 2013
Novice
 
Join Date: Dec 2015
Posts: 11
Graham Griggs is on a distinguished road
Default

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
Reply With Quote