I have a sheet that I import records from an Access table in to. After the records are imported, one of the things I want to do is copy all the VOID records into another sheet. In this first sheet the data is set up as a table.

The first time I did this, I created a named range (VoidedTickets) to use with a vlookup function in the second sheet. Everything works great.

I imported more records from Access into the first sheet. I filtered the records so I can copy the VOID records again and add them to the second sheet. All this is done thru VBA. I can do this.

I can increase (or Resize) the table in the first sheet with VBA.
How can I increase the size of the named range (thru VBA) to include the added records to the range so that the vlookup function will work with the added records and not with just the old records only?
I can increase the named range manually, but I need to do it with VBA.