Thanks, Andy, that looks promising. I'll try it out later.

As far as just copying the range, I've thought about that, but it's a named table object, and it gets a little more complicated to copy a table on top of another table and rename, etc.

I noticed that when I copied the whole sheet from one workbook to another, (after first deleting the sheet from the target workbook) that the table name stuck, so that's what I was trying to do.

I will consider both your suggestions.