Can Columns Resize Automatically???

  • Thread starter Thread starter Todd Huttenstine\(Remote\)
  • Start date Start date
T

Todd Huttenstine\(Remote\)

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
 
thank you
Nigel said:
Try this........

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

Cheers
N

need is




----== 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
Click to expand...
=---
 
Back
Top