Hi, how can i code in VBA for the print area for the area i want to print? regards, JOE
J JOE Aug 23, 2004 #1 Hi, how can i code in VBA for the print area for the area i want to print? regards, JOE
J JE McGimpsey Aug 23, 2004 #2 Take a look at "PrintArea Property" in XL/VBA Help: ActiveSheet.PageSetup.PrintArea = "A1:J10"
J Jon Peltier Aug 24, 2004 #3 Alternatively, Activesheet.Range("A1:J10").Name = "Print_Area" which avoids a trip to the slow PageSetup routine. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
Alternatively, Activesheet.Range("A1:J10").Name = "Print_Area" which avoids a trip to the slow PageSetup routine. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
