I'm using ActiveSheet.ListObjects("m
nlist to delete a Table but it gives me a Run-time error '9', "Subscript out of range" error (even though I can visually see the Table name and location in the Name Manager dialog) but if I then try to add the same "myTable" Table with an .Add parameter, I get another Run-time error '1004' error saying "A table cannot overlap another table" (and there are no other Tables that overlap this Table's Rows/Columns).
In the attached file, the calling sub that is causing the problem is "View_Room_Requirements_V1
" and the actual Table name I'm trying to delete if it exists (and then subsequently add back) is: "TABLE_Room_Requirements".
I got around the original error by only trying to Unlist it IF it exists, but the subsequent Add still doesn't work because I can't delete the Table.
Hope this is clear.