Results 1 to 2 of 2

Thread: Printing most of the Excel worksheets

  1. #1

    Printing most of the Excel worksheets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    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

  2. #2
    You could try this

    Code:
    Dim sh As String
    
        For Each sh In Array("Sheet1", "Sheet2") '<<<<<<<< add your sheets
        
            Worksheets(sh).Print
        Next sh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •