Selection.EntireRow.AutoFit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 17 Apr 2008 12:27 GMT

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?

Signature

Al C

Reply to this Message

Dave Peterson - 17 Apr 2008 13:45 GMT

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?threadm=e1%241uzL1BHA.1784%40tkmsftngp05

> XL2003 on XP
>
[quoted text clipped - 7 lines]
> --
> Al C

Signature

Dave Peterson

Reply to this Message

Al - 17 Apr 2008 13:55 GMT

Thank you, Dave

Signature

Al C

> That's one of the problems with merged cells.
>
[quoted text clipped - 12 lines]
> > --
> > Al C

Reply to this Message