Wednesday, December 30, 2015

Excel VBA AutoFit Method

Setting  The Width Of Columns According To The Cell Content

The Life-Saving Excel Feature You Probably Didn’t Notice.

Owing to code, Excel automatically adjusts the width of a column to accommodate the width of the text that takes up the most horizantal space in each row :

" Columns(Target.Column).AutoFit  "


No comments:

Post a Comment