PDA

View Full Version : Solved: how to print specific sheets?



lehgzil
10-20-2010, 08:35 PM
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...

mbarron
10-20-2010, 08:50 PM
Sheets(Array("Three", "Four", "Five")).PrintOut

lehgzil
10-20-2010, 08:53 PM
thanks mbarron,
ill try that later,
gotta have lunch first^_^

lehgzil
10-21-2010, 01:03 AM
thanks mbarron, it works fine...