View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave K Dave K is offline
external usenet poster
 
Posts: 16
Default 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?