Results 1 to 3 of 3

Thread: AutoFit Row height with cells that have a formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2015
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default AutoFit Row height with cells that have a formula

    Hi all - whenever I used AutoFit Row Height on a row that is referencing data from another sheet(Lets say, Im on Sheet1 and Cell A1 is referencing Sheet2!A7), the row height does not expand to fit all of the text. Is there a simple way to get this to work? Obviously there is no problem when data is entered directly on the sheet, it only has a problem with rows what are referencing data on other sheets. Thanks!
    Last edited by nyconfidential; Aug 23rd, 2019 at 09:24 AM.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    225
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: AutoFit Row height with cells that have a formula

    Do you have it formatted to Alignment, Wrap text?

  3. #3
    New Member
    Join Date
    Jul 2015
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: AutoFit Row height with cells that have a formula

    Quote Originally Posted by Toadstool View Post
    Do you have it formatted to Alignment, Wrap text?


    Thanks Toad - if I go back and manually click wrap text after the text has been inserted on the other sheet, that will work, but what I would like is for the row to expand when the text is entered on the other sheet. Im guessing Id have to do this through VBA. Thanks for your help!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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