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.
|