How can I find the name of all tables in Excel?

Did you change workSheet to something else? Let’s rule that out as the problem. You have a variable named the same as its type.

As I mentioned in topic with word application:
try to use this repair tool:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.