Word wrap and merged cells

[Chris]

Hi,

I have a cell (A1) formatted to enable word wrap. When
I've typed more text than the default column width allows,
I can double click on the bottom edge of the row to
automatically re-size my row for multiple lines. But if
my cell is a merged cell (A1 and A2), double clicking on
the bottom edge of the row no longer automatically re-
sizes my row. Instead, it reverts it back to the row
height of a single line of text. Does anyone know why
this is happening? Thanks!

 

[Paul B]

Chris, this is a problem, Bug?, in excel with merged cells

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Dave Peterson]

And if you'd like a macro solution:

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Chris]

Thanks! Works like a charm!

-----Original Message-----
And if you'd like a macro solution:

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?threadm=e1% 241uzL1BHA.1784%40tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--

Dave Peterson
(e-mail address removed)
.