Rename tables

[Len Silva]

I have a large workbook with a table on every sheet. There is only one table on a sheet. New sheets are added daily.
I would like a macro to rename the table the same as the sheet name. All my clumsy attempts have not worked.

Thanks in advance,

Len Silva

[ncmay]

The code below shows 3 options for the active sheet, 2 are inactive
This could be modified to loop through a workbook

Please Login or Register  to view this content.

[Len Silva]

Thanks, I'll try that.

Len

[nigelbloomy]

This may work as well.

Please Login or Register  to view this content.

[Len Silva]

Sweet and simple, thank you so much.

[nigelbloomy]

You are welcome. I'm glad it helped. Thanks for the rep too.