-
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...
-
[VBA] Sheets(Array("Three", "Four", "Five")).PrintOut[/VBA]
-
thanks mbarron,
ill try that later,
gotta have lunch first^_^
-
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
-
Forum Rules