CODEWITHSUNDEEP
excelvbaresize
Error 1004
Error 1004

Reputation: 8220

Resize Excel table with a number of rows & columns - VBA

I m trying to resize a table with a number of rows & columns without any luck. Below are the line of code with the error. Any help with appreciate.

tbl.Resize(2,3)

with the appove i tryin to increase tbl rows by 2 and tbl columns by 3.

Upvotes: 0

Views: 834

Answers (1)

Excel Developers
Excel Developers

Reputation: 2825

tbl.Resize tbl.Range(1,1).Resize(tbl.Range.Rows.Count + 2, tbl.ListColumns.Count + 3)

This will increment your table by two rows and three columns.

Upvotes: 1

Related Questions