Runtime error 1004 when creating/formatting a table with VBA

Hi. I'm new to your forum; an amateur VBA programmer from the Houston area.

I recorded this code in an attempt to create and format a table in Excel 2010.

Please Login or Register  to view this content.

When the ActiveSheet.ListObjects.Add(xlSrcRange, Selection, , xlYes).Name = "Master_List" statement executes, I get a runtime error 1004: "A table cannot overlap a range that contains a PivotTable report, query results, protected cells, or another table. "

Earlier in the code I do import a .csv file to the range I'm trying to turn into a table. Looking in the name manager, it appears that every time the import runs, a new name gets created: inserts, inserts_1, inserts_2, etc. I think if I could delete these names (are they listobjects?) after the insert this problem might go away. In any case, I'd like to clean up after myself.

Any suggestions?

Thanks for any help.

If you are just trying to re-run the macro you recorded, it may be that the table already exists. Maybe you should try deleting it first.

Regards, TMS

Ah, good to know you have a solution ... thank you for sharing it.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.