To install Greg's code, copy the code then in Excel, right-click on your
sheet tab and "View Code"

Paste the code into that module.


Gord

On Thu, 25 Feb 2010 11:53:01 -0800, confused outlook window
wrote:

Thanks for the information. Now I just have to figure out how to use VBA
code.

"Gord Dibben" wrote:

Merged cells will not respond to row autoheight.

Either get rid of them or you will need VBA code to deal with them.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Thu, 25 Feb 2010 08:51:02 -0800, confused outlook window
wrote:

I am having a similar problem with row autofit. I am using Wrap Text and
double clicking to autofit, but it won't seem to do it for merged cells (it
will for single cells). Is that just the way Excel 2007 was coded or am I
doing something wrong?


.