Auto reszie a row with wrapped text.

How do you autosize a row with wrapped text in a cell that spans
several lines and has control characters in it ie. vbcrlf ?

Put your cursor in the row and select
Format>Row>Autofit
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Timothy Marks" wrote:

>
>
> How do you autosize a row with wrapped text in a cell that spans
> several lines and has control characters in it ie. vbcrlf ?
>
>

Gary

This does not work. I would not have posted if that had worked.

Gary

This does not work. I would not have posted if that had worked.

sorry, it works for me.
--
Gary Brown

"Timothy Marks" wrote:

> Gary
>
> This does not work. I would not have posted if that had worked.
>
>

When you write spans several rows, do you mean the cells are merged?

If yes, then autofitting the row won't work.

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

Timothy Marks wrote:
>
> How do you autosize a row with wrapped text in a cell that spans
> several lines and has control characters in it ie. vbcrlf ?

--

Dave Peterson