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? |
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? |
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 |
All times are GMT +1. The time now is 01:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com