Excel VBA How to detect if Object Table1 exists, and if yes, change its name to Table2?

[Klash Ville]

I have a couple issues that I will explain using the names Table1 and Table2 for easy understanding.

I want to check if object Table1 exists, and if it does, to change its name to Table2 and Select it as well.

How can I achieve this?

 

[cerfani]

You can try to reference the table with a variable and then after test to see if the variable was set or if it "Is Nothing" ... you use with On Error Resume Next, so it doesn't crash if the table does not exist. Just try to reference the sheet and from that then I think you try to reference the table as a ListObject using the table name. If setting a listobject or tableobject variable fails then it doesn't exist.

To reset error handling, after you use "On Error GoTo 0"

 

[Klash Ville]

You can try to reference the table with a variable and then after test to see if the variable was set or if it "Is Nothing" ... you use with On Error Resume Next, so it doesn't crash if the table does not exist. Just try to reference the sheet and from that then I think you try to reference the table as a ListObject using the table name. If setting a listobject or tableobject variable fails then it doesn't exist.

To reset error handling, after you use "On Error GoTo 0"

Could you provide me the line of code related to the ListObject.Table1 please

I'm a bit confused