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 "
