Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel 2007 Printout Code

Comment:

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!!!

Name: DerbyDad03
Date: November 3, 2009 at 13:22:26 Pacific

Reply:

Something like this might work for you: Sheets(Array("Charts", "Activity Report")).PrintOut

0

linking appointments

Script to copy cell value...

Summary: I am not able to right click in Excel 2007. When I do so, nothing happens. I can right click in other programs including Word 2007 ...

Summary: Your file could not be printed due to an error on HP Officejet Pro K5400 Series on Neo1.Can print successfully in Word 2007, Outlook 2007, and WinXP. What are the default Excel files for WinXP profile...

Summary: Silly me. Nowhere in the code was copy or paste. :) I see the "=" in the For Next loop. I just don't know the syntax to VB well at all. I can sort of deduce what's going on from what little coding...