Print area in Excel, how to assign it to a range
Posted on 2011-03-02
I am tring to devleop a resizing program for our users to use during our massive rebranding project. A report could have three columns, or five, but it has to remain with certain margin paramaters. So, the first step I thought would be to turn the PageArea that is set by the user into a range (due to spaces between rows for "prettiness" cannot simpy use the UsedRange function). Is that possible? To take the PrintArea and assign it a RangeName with VBA?