title: excel vba resizing print area
body: <p>I have an excel tool that was made by someone before me. However, when the tool was made, it would output worksheets to a certain size that would fit the printable area in excel 2007. In excel 2010 however, the sizing is off. How can I change the size of the print area in a worksheet without having to change the size of individual cells in each sheet?</p>
  
  <p>Thanks for anyone who can offer their 2 cents.</p>