VBA: Search for table named 'x', then change name

[xtinct2]

Hello,

I want to write a code that searches my workbook for a table named 'DATA_CONSOL' then changes the name of that table to 'DATA_CONSOL_OLD'.
(ideally, the code would work so that if I run it multiple times, the first time it would rename the existing table to DATA_CONSOL_OLD, and the second time it would rename it to a unique name (e.g. DATA_CONSOL_OLD_2), then so on and so forth. However, if there is no table named 'DATA_CONSOL' in the workbook, it'd move to the next action in the code (since there'd be nothing to rename)
Is this possible?

Context (if you care):
I have a code that creates a table, and names it 'DATA_CONSOL'. And I want to adjust my code so that the most recently created table is always named 'DATA_CONSOL'. This way I can reference it via formulas and not have to worry about it pulling outdated data since the most recent macro run will always produce a table named 'DATA_CONSOL'. The code is written, I just need to add these lines to make it that much better.

This would be a HUGE help!

Thank you!

[Norie]

Will the table(s) be on a specific sheet or could it be on any sheet within the workbook?

[xtinct2]

Will the table(s) be on a specific sheet or could it be on any sheet within the workbook?

I could be on any sheet
(every time a table is made the macro creates a new sheet w/ a unique name)

[Norie]

Why don't you rename the last table made before creating the new table?

[xtinct2]

Why don't you rename the last table made before creating the new table?

Hoping I can insert code to automate this so that I dont need to manual change a table's name to a unique one every time i wanna run the macro
Is this possible?
Thanks!

[xtinct2]

Why don't you rename the last table made before creating the new table?

nevermind, figured it out:

On Error Resume Next
Application.Goto Reference:="DATA_CONSOL"
ActiveSheet.ListObjects("DATA_CONSOL").Name = "DATA_CONSOL_OLD"

Thanks!

[Norie]

Glad you got a solution.

PS I wasn't suggesting doing what I suggested in post #4 manually.