+ Reply to Thread
Results 1 to 2 of 2

Macro to Automatically Format Cell to Correct Height

  1. #1
    Registered User
    Join Date
    07-26-2006
    MS-Off Ver
    Office 365
    Posts
    97

    Macro to Automatically Format Cell to Correct Height

    Hello,
    I am trying to accomplish what I feel should be an easy macro, just above my level.
    A range on one my worksheets (say B10:H20) may have lengthy text in cells that will wrap based on row and column height and width. The text amounts vary, sometimes between only two lines wrapped, up to 10 lines wrapped within the same cell.
    I am looking for a macro that will run automatically, and adjust the row height to fit whatever text is inputted as its inputted. Hopefully, this makes sense. Any feedback helps. Thanks,

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Macro to Automatically Format Cell to Correct Height

    If your cell is set to wrap, then the row height usually adjusts automatically when text is entered. I don't know what your circumstances are in which this is not happening, but the method to adjust the height is .Autofit.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-12-2015, 02:52 PM
  2. Insert row automatically with correct format and drop down list
    By exclaymation in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2013, 04:56 AM
  3. Automatically adjust row height in merged cell
    By jennifersmigla in forum Excel General
    Replies: 0
    Last Post: 03-16-2013, 01:15 PM
  4. a macro to format a row height and font, dependant upon a cell content
    By PeterF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2011, 02:56 AM
  5. [SOLVED] Text Wrap, Cell Height Does NOT Automatically Adjust
    By Al Franz in forum Excel General
    Replies: 1
    Last Post: 01-24-2005, 10:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1