Is Automatic Cell Expansion Possible?

[StacyTheis]

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?

 

[Gord Dibben]

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

 

[StacyTheis]

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