simple? print area?

G

Guest

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!
 

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

Set Print Area with Dynamic Start Point 2
Print Area Range Selection 2
Page break macro based on cell content / formula 3
Set Print Area 3
Need Help in Selecting PrintArea Dynamically .. 0
Set print range for individual sheets (ranged) in workbook. 2
Set Print Area 2
Last Used Cell 6

Top