Changing the print_area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With code I would like to change the print_area range to be the same as
another range. Something like these three lines (though this doesn't work):

Dim r As Range
Set r = range("myRange")
Range("print_area") = r

How do I do this?
 
If you check "PrintArea" in the Help or the Object Browser, you will see if
returns/sets a String.
So you need to pass the address of the Range object, not the Range object
itself.

NickHK
 

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

Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Determining if ChartObject is in PrintArea on Worksheet 5
Deleting all Range Names except Print_Area? 2
Ranges, adding a column to a named print range then saving the file 1
increasing the size of a named range and saving it back to the spreadsheetI 4
macro only prints out first and last line of document 7
Print_Area link problem 3

Back
Top