+ Reply to Thread
Results 1 to 2 of 2

Text Wrap - Automatically expand based off of referenced cell w/text from another sheet?

  1. #1
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Southern Cali
    MS-Off Ver
    2013
    Posts
    104

    Text Wrap - Automatically expand based off of referenced cell w/text from another sheet?

    Hello,

    Setup:

    Five sheets
    Sheet one is the Executive summary sheet.

    I have the other four sheets feeding information to the Executive sheet. I have set the Text wrap on the cells in question that are set to populate the information from the other cells on the four other sheets.

    However, the cell is not expanding on the Executive sheet. I am having to manually expand the cell. It works if I manually type in something, but not when it is coming from another sheet via a reference.

    So, is there a way to have the cell automatically adjust the height based on the reference content?
    Last edited by rhett7660; 02-05-2016 at 05:49 PM.

  2. #2
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Southern Cali
    MS-Off Ver
    2013
    Posts
    104

    Re: Text Wrap - Automatically expand based off of referenced cell w/text from another shee

    I was able to get this to work by doing the following:

    Created a macro called AutoFitCell

    Please Login or Register  to view this content.
    Then created another Macro that activates the above code via a BeforeSave:

    Please Login or Register  to view this content.
    Seems to be working.

+ 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: 3
    Last Post: 02-03-2016, 09:22 PM
  2. VBA to expand Wrap Text area when printing
    By stevesince1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2015, 09:33 PM
  3. Wrap the Cell based on the text Returned by the Function
    By Kandavalli.Kiran in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2015, 10:10 PM
  4. How do I automatically expand a merged cell with wrapped text?
    By MCOE Excel User in forum Excel General
    Replies: 1
    Last Post: 01-26-2005, 03:06 PM
  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
  6. [SOLVED] Excel merged cell - can it automatically expand as text is typed?
    By Joanne (JAS) in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-07-2005, 09:06 PM
  7. [SOLVED] Excel merged cell - can it automatically expand as text is typed?
    By Joanne (JAS) in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-07-2005, 07:06 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