Hi all,
I am using the autofilter to filter the database as the coding showed below.
In the database, the number "1190" does not exist. Hence, the coding suppose is work and will paste a new original table on another worksheet. However, when i run the coding, error message is pop up showed "Run Time Error "1004":A table cannot overlap another table." and pointed to the command Sheets("Group_A").ListObjects.Add(xlSrcRange, Rng, , xlYes).Name = "_Table".
I can't figure out the solution of this problem. Please help me.
Thanks.
Bookmarks