Rename table from another sheet.

[Mihael]

Hello everyone,

I want to rename a table with a Macro from another sheet. When I do this, it will not change the name. The reason I want to do this, is that the table name changes when I use a different Macro.

Does anyone know how to manage this?

Thanks in advance!

 

[Mihael]

Alright thank you!

 

[Mihael]

Hi, I worked it out without a Macro. I just clicked the cell in the table, and filled in = then I clicked the cell in the other table and pressed enter. So now it works!

Many thanks for helping me!

 

[iconiuss]

Glad you got it sorted, sorry I couldn't be more help.