PRINT AREA IN PROGRAMMING

  • Thread starter Thread starter JOE
  • Start date Start date
J

JOE

Hi,

how can i code in VBA for the print area for the area i
want to print?

regards,
JOE
 
Take a look at "PrintArea Property" in XL/VBA Help:

ActiveSheet.PageSetup.PrintArea = "A1:J10"
 
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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to set dynamic print area 1
Print with sevral different print area's 2
Set Print Area with Dynamic Start Point 2
Can I save different print areas? 3
Macro to control Print area/view 2
Setting print area 3
Format last row printed 1
Print Setup Not Set 1

Back
Top