XL2003 on XP

Selection.EntireRow.AutoFit

When I use this with most rows, it does what I expect. However, if the row
has merged cells with wrap text on and an entry long enough to cause it to
wrap, this line causes the row height to shrink to the default? of 12.75.
Does anyone have an explanation or a workaround?

--
Al C

That's one of the problems with merged cells.

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?thre...%40tkmsftngp05



Al wrote:

XL2003 on XP

Selection.EntireRow.AutoFit

When I use this with most rows, it does what I expect. However, if the row
has merged cells with wrap text on and an entry long enough to cause it to
wrap, this line causes the row height to shrink to the default? of 12.75.
Does anyone have an explanation or a workaround?

--
Al C

--

Dave Peterson

Thank you, Dave
--
Al C


"Dave Peterson" wrote:

That's one of the problems with merged cells.

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?thre...%40tkmsftngp05



Al wrote:

XL2003 on XP

Selection.EntireRow.AutoFit

When I use this with most rows, it does what I expect. However, if the row
has merged cells with wrap text on and an entry long enough to cause it to
wrap, this line causes the row height to shrink to the default? of 12.75.
Does anyone have an explanation or a workaround?

--
Al C

--

Dave Peterson