Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another

[Dave K]

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?

 

[Jim Cone]

Re: "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" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

Check your other post.

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?