Autofit Row & Merged Cells

[Alex Burman]

Is this just me or is it a common problem:

I have some text in a cell. The cell is merged along a row with the adjacent
cells, I have put word wrap on. Now Autofit Row doesn't work and only shows
the first line of text.

Is there anything I can do, apart for manually adjust the row height?

Regards

 

[J.E. McGimpsey]

Take a look at this macro by Jim Rech:

http://google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05


If you need help getting started with macros, look at David
McRitchie's Getting Started with Macros page:

http://www.mvps.org/dmcritchie/excel/getstarted.htm