Share via

Excel VBA Runtime Error 1004

Anonymous
2018-06-25T16:14:38+00:00

I am trying to run the following macros and error 1004 keeps showing up saying that "A table can't overlap another table." 

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-06-25T18:11:47+00:00

If you are trying to run the macro a second time, then the table exists and you'll get that error. You could delete all the tables before trying to add one, but there really is no need.

If you have tables that you don't knwo the name of, you could just use the index to manipulate the table.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest