How to Copy a full Table object

It would be best if you uploaded a sample workbook so that a more precise answer could be given.

However, here is a basic approach using two options (the last two lines of code before "end sub" are method #2 and are commented out). There are other ways as well, but given the lack of deatails and no example workbook this is the best we can do.

Please Login or Register  to view this content.