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 ?

Auto reszie a row with wrapped text.
 

Put your cursor in the row and select
FormatRowAutofit
HTH,
--
Gary Brown

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 ?

Auto reszie a row with wrapped text.
 

Gary

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

Auto reszie a row with wrapped text.
 

Gary

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

Auto reszie a row with wrapped text.
 

sorry, it works for me.
--
Gary Brown

"Timothy Marks" wrote:

Gary

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

Auto reszie a row with wrapped text.
 

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