autofit: cell height expands with text entered?

[Sandy]

For a form:
can a user enter mass quantities of text in a cell and
have the cell depth expand so it fits?
does Merging Cells limit this ability? I made a giant cell
to handle the text the user might enter.

I can't figure out where to set this...
I have copied & pasted formatting from one worksheet to
another without luck.

Thanks.
Sandy

 

[Dave Peterson]

Merged cells don't adjust rowheight for wrapped text (like non-merged cells do).

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05