Thanks. I will try it.

"Dave Peterson" wrote:

Autofitting rowheight and merged cells don't play nice.

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?thre...%40tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Pat wrote:

I have tried to autofit and format cell, but nothing works. I have to
manually drag the cell border to make it longer.

--

Dave Peterson