Resize a Table using VBA
I believe you would have to re-define your table.
"OMER" wrote in message
...
I have a named table (not a range) that I need to resize depending on the
number of cols and rows from another worksheet. I tried the approach used
to
resize ranges but it doesn't work for Tables. I can resize it using the
Ribbon-Table Tools, but these commands don't get recorded in the Macro
Recorder.
Is there code to accomplish this dinamycally inside a macro?
Regards,
OMER
|