Merged cells will allow "wrap text" from FormatCellsAlignment but..........
Excel has a problem auto-fitting merged cells.
You can resize manually or via Macro. Jim Rech has written
code for this.
http://groups.google.com/groups?thre...%40tkmsftngp05
Note also a recent adaptation of this code by Greg Wilson.
http://makeashorterlink.com/?P37D24B15
The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.
Gord Dibben Excel MVP
On Fri, 29 Oct 2004 09:54:15 -0700, 6-shooter
wrote:
Merged cells seem to be treated differently than single cells when it comes
to this functionality. Are there any tricks to working around this issue?