Posted to microsoft.public.excel.programming
|
|
Selection.EntireRow.AutoFit
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
|