Way to print every worksheet in a workbook except the first two

[akbnsl]

Does anyone know a way to write VBA code that allows excel to print
every worksheet in a workbook except the first two worksheets? Any
help you could offer would be greatly appreciated.

Thanks

 

[Chip Pearson]

Try code like

Sub AAA()
Dim N As Long
With ActiveWorkbook.Worksheets
For N = 3 To .Count
.Item(N).PrintOut
Next N
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[akbnsl]

Try code like

Sub AAA()
    Dim N As Long
    With ActiveWorkbook.Worksheets
        For N = 3 To .Count
            .Item(N).PrintOut
        Next N
    End With
End Sub

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
    Excel Product Group
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)







- Show quoted text -

Worked perfectly. Many thanks.