Consulting

Results 1 to 4 of 4

Thread: Solved: how to print specific sheets?

  1. #1
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location

    Solved: how to print specific sheets?

    gud day everyone,
    i would like to ask how to create a vba code that print specific sheets on a workbook.

    for example. my workbook contains 5 sheets and i would like to print only the 3rd,4th and 5th sheet.
    sheet1 is named One
    sheet2 is named Two
    sheet3 is named Three
    sheet4 is named Four
    sheet5 is named Five


    thanks in advance...

  2. #2
    VBAX Mentor
    Joined
    Jun 2004
    Posts
    363
    Location
    [VBA] Sheets(Array("Three", "Four", "Five")).PrintOut[/VBA]

  3. #3
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location
    thanks mbarron,
    ill try that later,
    gotta have lunch first^_^

  4. #4
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location
    thanks mbarron, it works fine...

Posting Permissions

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