due to working with an Exceltool I want that a VBA- Programm prints out 8 of ten worksheets. The problem for me is now, that I have to initialice a printer and that I den't know how I could programm that not all worksheets would be printed out.
Thanke you very much for your help
You could try this
Code:Dim sh As String For Each sh In Array("Sheet1", "Sheet2") '<<<<<<<< add your sheets Worksheets(sh).Print Next sh