Column width of ListObject

[rdilipk]

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?

 

[rdilipk]

OK. I just noticed that I can do:

ListObject.Range.Autofit

But my issue with that is the range of my ListObject expands dynamically as I batch-insert rows into it. Would that matter?

 

[Norie]

Why not autofit the listobject's range?

Dim lst As ListObject

    Set lst = ActiveSheet.ListObjects(1)
    
    lst.Range.Columns.AutoFit

 

[rdilipk]

Why not autofit the listobject's range?

Dim lst As ListObject

    Set lst = ActiveSheet.ListObjects(1)
    
    lst.Range.Columns.AutoFit

That works great! Thanks. I missed the Columns property of Range.