Auto fit wrapped and merged cells
 

Using Excel 2003 if you have a number of cells that are merged and wrapped
how can you get the rows to auto fit height - I am sure this used to work on
previous versions of excel but does not seem to now (similarly for columns).
Is there a fix for this or an option I need to select or deselect?

Hi Elmo,

See this macro from Jim Rech:


http://tinyurl.com/4c5l6


---
Regards,
Norman



"elmo2" wrote in message
...
Using Excel 2003 if you have a number of cells that are merged and wrapped
how can you get the rows to auto fit height - I am sure this used to work
on
previous versions of excel but does not seem to now (similarly for
columns).
Is there a fix for this or an option I need to select or deselect?