Consulting

Results 1 to 5 of 5

Thread: Formula to format the cell? (so text gets enough space)

  1. #1

    Formula to format the cell? (so text gets enough space)

    Hello.

    Im using a sub that copies the sheet, then deletes blank rows. The only problem i have is... the Cell is often too small for the text. You can easily fix this manualy in Excel just by pressing the edge of sheet number twice, but i want it done automaticaly. Could you please help me?

    PS. The width of cell remains the same, just the height needs the fix

    problem.jpg

  2. #2
    you Right-Click on the Cell.
    Format Cells->Alignment->Wrap Text.

  3. #3
    Quote Originally Posted by arnelgp View Post
    you Right-Click on the Cell.
    Format Cells->Alignment->Wrap Text.
    Im sorry but it doesnt work the way i need it to work. I have many columns in my sheet, and unchecking Wrap makes half of my cell dissapear (due to text in collumn on the right of it). Checking it results in a problem described in this post, which i need to fix.

    I cannot pre-format the cells, as its a Generator (you put a code in a cell, Excel gives a result, the letters are always various. It can be a short word, or several long words).
    Attached photo was the way i want it to work, not a part of my work
    Last edited by asktheages; 11-25-2022 at 02:51 AM.

  4. #4
    VBAX Expert
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    901
    Location
    Maybe:
    Cells.EntireRow.AutoFit
    If things don't change they stay the same
    Quite often there is a picnic problem (problem in chair not in computer)
    "We were not told it was impossible, so we did it."

  5. #5
    Thank you !!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •