Well, bummer. Thank you, Gord.
"Gord Dibben" wrote:
Mick
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 Mon, 14 Feb 2005 07:23:04 -0800, "Mick"
wrote:
Is there a way to get merged cells to resize with context (autofit)? I can't
seem to get it in 2003.