resize table in excel by vba

Question

Hello
I want to change table size by vba module. I have variable data row in one sheets an I want to show variable data row in table ; when I add one row in frist sheet expand table automaticaly and show true rows.

Answer 1

Not very clear what you mean or looking for.

I want to change table size by vba module

Start the macro recorder, do the modification, stop the recorder and you have your VBA code, a resize of column "A" looks like

Columns("A:A").ColumnWidth = 32.0

Answer 2

Here is an example that uses the VBA "resize" code
to resize the result of an Advanced Filter application.
Power Query would do all this automatically and easier.
https://www.mediafire.com/file/kgb3p5p2yad06s3/07_23_11.xlsm/file
https://www.mediafire.com/file/v9law32xyk27ml9/07_23_11.pdf/file