On Aug 13, 2:48*pm, Damian wrote:
THANK YOU Gord. * Got it working.



"Gord Dibben" wrote:
One more reason, among many, not to use merged cells.

For worksheeteventcode...............

See google search thread forcodeby Greg Wilson. *Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micro...isc/browse_frm...

Gord

On Wed, 12 Aug 2009 13:57:03 -0700, Damian
wrote:

I do have Merge cells how do I write thecode?

"Gord Dibben" wrote:

FormatRowAutofit.

Unless you have merged cells in the range.

In that case row autofit will not work and you must addeventcodeto
autofit.

Gord Dibben *MS Excel MVP

On Wed, 12 Aug 2009 07:34:02 -0700, Damian
wrote:

Well not the single cell but the whole row can right? I know I did it before.
When you type and its larger then the cell and you have wrap text it will
automatically expand the whole row to fit the text.

"Bernard Liengme" wrote:

A cell never expands when text is added (only when numbers are added and the
width has not been preset)
Wrap Text does nothing until you use ALT+ENTER to make a line break
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Damian" wrote in message
...
Probably an easy question, how can I make the cells expand automatically
to
fit the text. I have Wrap Text on but the cell does not expand.

Thanks

I tried inserting the code but had trouble with it - probably because
I've never used codes before. If anyone has tips for a beginner I
would greatly appreciate it. Also, I've used merged cells quite a bit
and discovered from this group that it's not the best thing to do. Why
is that and what are the alternatives? I just discovered this group so
thank you all in advance for taking time out to supply help.