LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove print area from multiples pages Linda Excel Discussion (Misc queries) 1 April 8th 10 06:21 PM
Setting the print area in page set up to print 1 page wide by 2 pages tall EA[_2_] Excel Discussion (Misc queries) 2 July 12th 07 08:39 PM
Print Area ranges print on separate pages? Lyndon Excel Discussion (Misc queries) 1 December 29th 06 05:22 PM
Set print area on several pages at once in Excell Workbook? willow Excel Discussion (Misc queries) 2 August 23rd 05 01:31 AM
Print area will only go up to 101 pages Martc Excel Discussion (Misc queries) 1 June 23rd 05 12:50 AM


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"