View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] akbnsl@gmail.com is offline
external usenet poster
 
Posts: 6
Default 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.