What is the best way to adjust the width of each column in a ListObject to the maximum length of its content? Currently the column width seems to correctly fit the name of the column but the contents just spill outside.
I see a ListObject.QueryTable.AdjustColumnWidth but that is supposedly true by default.
Yet another way is Range.Column.Autofit but I can't believe I will have to do this for every column in my ListObject.
Clearly I am missing something here. Can someone help?
I see a ListObject.QueryTable.AdjustColumnWidth but that is supposedly true by default.
Yet another way is Range.Column.Autofit but I can't believe I will have to do this for every column in my ListObject.
Clearly I am missing something here. Can someone help?