Excel Table VBA Resize based on another Column Last Populated Cell

[ibuhary]

Hi All,

I would like to Resize my Table in the attached workbook based on the last Populated Cell in "Column D" (i.e. until Row 33).

We need to do this via VBA Code as this code will go inside another macro.

[Bo_Ry]

Please try

Sheets(1).ListObjects("Table1").Resize Range("A3:B" & Range("D" & Rows.Count).End(xlUp).Row)

[ibuhary]

Wow so Simple.
Thanks and that was cool.
Just in a Single line ...