View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Way to print every worksheet in a workbook except the first two

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)



wrote in message
...
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