Thank you gentlemen.
Fogive the double posting, but MS said my msg wasn't sent and to try later.
Even on the 2nd try, it said it was not sent and to try later.
Evidentally, that was the "default" confirmation yesterday.

I'm having trouble finding what to do with the Events, but I'll keep reading.
--
MichaelM


"David McRitchie" wrote:

That is definitely a problem and a solutions are occasionally posted. Once
you set a definite row height you are stuck with having to reset it when
needed. Here is my solution:

Adjust row height automatically(#autofit)
Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm

There has also been a posting to remove specific height
and that one will be harder to find, and let Excel work with them again,
but things like merge cells will interfere with this. Can't believe
I actually found it (was referenced by Gord Dibben, that helped) -- written by Jim Rech
If you have merged cells you will want to use this one.

http://www.google.com/groups?threadm...40TK2MSFTNGP10

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MichaelM" wrote in message ...
We have a situation where we enter large amounts of text in cells.
The cells are set to wrap and are limited in width so you actually have to go into those cells, and edit, in order to read them.

But, when we print, we only get what the cell height is set to and can't see all the text, unless we manually drag the cell height
down (as far as we can).

Is there a type of "can grow" property for cells or the sheet that is used with printing? Can't find it.

Thanks, Michael