Thank you for your response. The cells are not merged and
I have not manually resized them, wrap text is enabled.
After realizing none of this worked I did have to go in
and resize them manually, but I really appreciate the code
and link reference, I'll check them out. Thanks again.
-----Original Message-----
Are any of the cells "merged"?

Row Autofit doesn't work properly with merged cells.

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has
written
code for this.

http://groups.google.com/groups?threadm=e1%
241uzL1BHA.1784%40tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

If not merged, did you recently manually re-size the row
(s)?

This can screw up Autofit. Select all rows and
FormatRowsAutofit again.

Is wrap-text enabled?

Gord Dibben Excel MVP

On Wed, 30 Jun 2004 16:47:00 -0700,

wrote:

So sorry, I meant taller, thank you


-----Original Message-----
Wider/skinnier refers to Column.

Taller/shorter refers to Row.

Try FormatColumnAutofit.

Gord Dibben Excel MVP

On Tue, 29 Jun 2004 16:20:43 -0700,

wrote:

Can someone please tell me why my text will not fit in
Autofit row. It just needs to be a little bit wider.
It
never used to do this, is it because I'm now using
Windows
XP with Excel 2000?

.


.