Can Columns Resize Automatically???
 

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

Can Columns Resize Automatically???
 

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 =---

Can Columns Resize Automatically???
 

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 =---

Can Columns Resize Automatically???
 

thank you
"Nigel" wrote in message
...
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
=---