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