Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resize chart automatically when window size changes? | Charts and Charting in Excel | |||
Automatically resize excel charts when exporting them to PowerPoin | Charts and Charting in Excel | |||
Automatically resize columns based on new formula result | Excel Discussion (Misc queries) | |||
Pie Charts Resize Automatically - How To Avoid? | Charts and Charting in Excel | |||
Urgent help! how to automatically resize all the charts? | Excel Worksheet Functions |