Wrap Text in a merged cell

[tdimaggio4]

I am trying to let the text wrap inside of a merged cell (formally 3 cells) how do you get it to show up in the cell without having to manually adjust the row height? I tried using the automatic row height and it doesn't seem to work.

HELP!!

 

[Andrew Poulsom]

Try Jim Rech's code:

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

 

[tdimaggio4]

looks good but it gives me a syntax error

 

[Andrew Poulsom]

looks good but it gives me a syntax error

Remove the line feed from the end of:

MergedCellRgWidth = CurrCell.ColumnWidth +

so that:

MergedCellRgWidth = CurrCell.ColumnWidth + MergedCellRgWidth

is all on one line.

 

[royUK]

I would avoid Merged Cells, they are a constant source of problems