View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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