ExcelBanter - simple? print area?

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

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

- - simple? print area? (https://www.excelbanter.com/excel-programming/374397-simple-print-area.html)

John

simple? print area?

I get unable to set print area error on the last line of code...
Range("b12:" & Range("j65536").End(xlUp).Address).Select
Set prtselect = Selection
ActiveSheet.PageSetup.PrintArea = prtselect

any help is appreciated!

Alok

simple? print area?

try
ActiveSheet.PageSetup.PrintArea=prtselect.address

"John" wrote:

I get unable to set print area error on the last line of code...
Range("b12:" & Range("j65536").End(xlUp).Address).Select
Set prtselect = Selection
ActiveSheet.PageSetup.PrintArea = prtselect

any help is appreciated!

John

simple? print area?

Thanks!

"Alok" wrote:

try
ActiveSheet.PageSetup.PrintArea=prtselect.address

"John" wrote:

I get unable to set print area error on the last line of code...
Range("b12:" & Range("j65536").End(xlUp).Address).Select
Set prtselect = Selection
ActiveSheet.PageSetup.PrintArea = prtselect

any help is appreciated!

All times are GMT +1. The time now is 02:30 PM.