(Solved) – Add the row below a table to the table range


I am trying to resize a table to include the data in a row directly below the last row in a table. My current code looks like this but returns an object defined error. Also, the table changes location as rows are added both above and below it.

tbl.resize tbl.Range.CurrentRegion.Offset(1, 0)

I have used the following sources to try and resolve this problem with no luck. Resize Listobject Table dynamically with VBA

Leave a Reply

Your email address will not be published. Required fields are marked *