使用VBA动态调整Listobject表的大小

I want to change the size of the object tables through VBA, I tried modifying the code from msdn.microsoft.com about listobject.resize method but I want to dynamically if a data loaded in each row.I want to change the size of the object tables