print pages when text area changes in size
 

Hi! Hopefully someone can help me out or point me in the righ
direction. I'm new to this.

Here is my problem: I have an Excel VBA with multiple sheets in th
workbook. One of the sheets has several text areas set on the page.
These text areas can be increased or decreased in size based on th
amount of text entered by the user. Average amounts of data are fine
but increasing the size causing the text box to run to the end of th
page then on the next page repeat the last line of the first page an
continue printing.

I need to get rid of that repeating line and find a way for the tex
box to outline at the bottom of the first page and the top of th
second page. I have the print area set to fit 1 wide with no numbe
for tall.

I also would like recommendations on a good book to use as referenc
material. Thank you

--
Message posted from http://www.ExcelForum.com