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

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

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

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

On Aug 6, 6:53*pm, "Chip Pearson" wrote:
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)

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- Hide quoted text -

- Show quoted text -

Worked perfectly. Many thanks.