Try this........

Worksheets("Sheet1").Columns("A:IV").AutoFit

Cheers
N

"Todd Huttenstine(Remote)" wrote in message
...
Is there a code that I can use in a worksheet or range that will autosize
the column based on the length of the word or value inside the cell. For
instance if the value "dog" was inside cell A1, the column would not need
to
be very big for me to see the entire word, but if I were to type "That is
a
very big dog" inside cell A1, then I would like for the column to
automatically be resized so I could see the value.

Thanx

Todd Huttenstine






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---