Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another cell?
I am trying to display the results from one tab (Tab 1) in another
(Tab 2). So, for example, tab 2 contains the formula "=Tab1!A2". However, when the results are too large to fit the cell in tab 2 (i.e., the cell that contains a formula that draws from a cell in tab 1), the wrap text feature does not work unless i first double click in the cell in tab 2. Is there any way around this? Can the wrap text feature work automatically somehow? Or will i need to double click in every cell that contains text that doesn't fit into the cell. Thanks for any suggestions, or VBA code, that might make this possible. Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell?
"Can the wrap text feature work automatically somehow?" If the formula is already in the cell, then try code line 2, or code lines 2 and 3... Change "F20" to the appropriate cell location. '--- Worksheets(2).Range("F20").Formula = "=Sheet1!A2" Worksheets(2).Range("F20").WrapText = True Worksheets(2).Range("F20").EntireRow.AutoFit -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Extras for Excel add-in: convenience built-in) "Dave K" wrote in message ... I am trying to display the results from one tab (Tab 1) in another (Tab 2). So, for example, tab 2 contains the formula "=Tab1!A2". However, when the results are too large to fit the cell in tab 2 (i.e., the cell that contains a formula that draws from a cell in tab 1), the wrap text feature does not work unless i first double click in the cell in tab 2. Is there any way around this? Can the wrap text feature work automatically somehow? Or will i need to double click in every cell that contains text that doesn't fit into the cell. Thanks for any suggestions, or VBA code, that might make this possible. Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Auto Expansion (i.e., wrap text) of a cell possible whenthe cell's contents are based on another cell?
Check your other post.
On 01/28/2011 13:13, Dave K wrote: I am trying to display the results from one tab (Tab 1) in another (Tab 2). So, for example, tab 2 contains the formula "=Tab1!A2". However, when the results are too large to fit the cell in tab 2 (i.e., the cell that contains a formula that draws from a cell in tab 1), the wrap text feature does not work unless i first double click in the cell in tab 2. Is there any way around this? Can the wrap text feature work automatically somehow? Or will i need to double click in every cell that contains text that doesn't fit into the cell. Thanks for any suggestions, or VBA code, that might make this possible. Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my text in a cell with wrap text and auto height get cut | Excel Worksheet Functions | |||
What controls row expansion to show muli-line text in a word-wrap | Excel Discussion (Misc queries) | |||
auto row height a cell with wrap text enabled and a lot of charact | New Users to Excel | |||
Auto Text Wrap in a Cell | Excel Discussion (Misc queries) | |||
Auto-checking a checkbox based on cell contents. | Excel Programming |