I'm currently making a template document that has a section in it with
several merged cells where the user can enter comments about a certain
client. Is there a way for the cells to automatically expand down if
the user adds more comments than the space already provided? Or will
the user have to just add rows manually?




--
StacyTheis

The fact of using the dreaded "merged cells" function means you cannot have
row>autofit functional without using event code

The expansion down can be done in a single cell with wrap text and row>autofit
or column>autofit enabled.

But not to the next cell. That would require manual input.


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 16:04:18 +0100, StacyTheis
<(E-Mail Removed)> wrote:

>
>I'm currently making a template document that has a section in it with
>several merged cells where the user can enter comments about a certain
>client. Is there a way for the cells to automatically expand down if
>the user adds more comments than the space already provided? Or will
>the user have to just add rows manually?

Thanks so much for your reply. I didn't think there was a way. Thanks
for confirming that!

StacyTheis;681890 Wrote:
> I'm currently making a template document that has a section in it with
> several merged cells where the user can enter comments about a certain
> client. Is there a way for the cells to automatically expand down if
> the user adds more comments than the space already provided? Or will
> the user have to just add rows manually?




--
StacyTheis