TechRepublic|Forums|Software

Software

General discussion

  • Creator
    Topic
  • March 14, 2005 at 7:21 am #2175588

    text area in MS Excel 2000 VBA

    Locked

    by polanis · about 18 years, 6 months ago

    I have this worksheet whose first sheet is the “input” sheet while all the other sheets are protected sheets whose input comes from the first sheet. Now i have been trying to find a solution to having a test area which will take the input and paste it into the output sheets. The problem that occurs is the formatting. I want them to fit in the print area and be word wrapped. Does anybiody has an idea as to how to accomplish this?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • March 16, 2005 at 5:55 am #3350673

      Reply To: text area in MS Excel 2000 VBA

      by madcatr · about 18 years, 6 months ago

      In reply to text area in MS Excel 2000 VBA

      Using the Edit->Fill->Justify for the print area range will word wrap the text for you. However, there is one major caveat; if the amount of text when set within the range is greater in size; i.e., it is below your print area, it will go below and it will not print unless you print to fit on one page.

  • Author
    Replies
Viewing 0 reply threads