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.
resize table in excel by vba
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
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
5 people are following this question.
