ExcelBanter - PRINT AREA IN PROGRAMMING

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - PRINT AREA IN PROGRAMMING (https://www.excelbanter.com/excel-programming/307722-print-area-programming.html)

joe

PRINT AREA IN PROGRAMMING

Hi,

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

regards,
JOE

JE McGimpsey

PRINT AREA IN PROGRAMMING

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

ActiveSheet.PageSetup.PrintArea = "A1:J10"

In article ,
"JOE" wrote:

Hi,

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

regards,
JOE

Jon Peltier[_8_]

PRINT AREA IN PROGRAMMING

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/
_______

JE McGimpsey wrote:
Take a look at "PrintArea Property" in XL/VBA Help:

ActiveSheet.PageSetup.PrintArea = "A1:J10"

In article ,
"JOE" wrote:

Hi,

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

regards,
JOE

All times are GMT +1. The time now is 03:09 AM.