Ok, here's the MS confirmation of my just tried Reply post, today 6/11 at 1000R (10:00AM Eastern Standard Time).
An error occurred while sending your post
--------------------------------------------------------------------------------
We're sorry, but there was a problem with the system and your post was not received. The error has been reported to Operations and will be investigated as soon as possible. Please try again later.
But, it's probably out there so I won't repeat it.
I did 'check' "Notify me of replies".
--
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