Excel 2007 Printout Code

Microsoft Excel 2007
November 3, 2009 at 12:59:34
Specs: Windows XP
I'm trying very hard to figure this out. I have a workbook with about 8-9 different worksheets at any given time. Two of the sheets (which are not next to each other) I need to be able to print. I'm trying to figure out the code to put in my command button to print only those two sheets when you click it. The sheets names for instance are "Charts" and "Activity Report". Any help would be greatly appreciated!!!

See More: Excel 2007 Printout Code

Report •

November 3, 2009 at 13:22:26
Something like this might work for you:

Sheets(Array("Charts", "Activity Report")).PrintOut

Report •
Related Solutions

Ask Question