Thread: Print Area to include text box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul Doucette Paul Doucette is offline
external usenet poster
  
Posts: 40
Default Print Area to include text box
On Tuesday, January 6, 2015 8:51:49 AM UTC-5, Paul Doucette wrote:
How can I set a print area on Sheet 1 from A1 (upper left) to the lower right corner of a text box regardless of where the text box is located?
Thanks!

Thank you for that.
My current print area is A1 to AG50. The text box sits on A17 to AG50. And it prints fine. However, sometimes the text box gets resized to a17 to AK75 or beyond, so I need the print area to increase so that part of the text box does not get cut off.
Many thanks, Paul
Reply With QuoteReply With Quote