Create a list of all table names in Workbook

[Bonnister]

Hello

Just as the title suggests, I'm looking for a piece of VBA code that simply creates a list of all table names contained within a workbook. The first column would contain the name of each table, and the second column would contain the worksheet the table sits on. Any help in this matter would be massively appreciated

Thanks all
Kenny

[bakerman2]

Something like this should work.
Create a sheet called Summary to write results too.

Please Login or Register  to view this content.

[YasserKhalil]

Hello try this code

Please Login or Register  to view this content.

[Bonnister]

Thank you both, both solutions work perfectly!

[YasserKhalil]

You're welcome. Glad it worked for you
Please mark the thread as solved

Regards