Get table name on worksheet using formulas without using VBA

[sspatriots]

Happy New Year!

I have a worksheet that list all of the worksheet names in the workbook by tab order from left to right. Column A shows the actual Worksheet number and Column B returns the corresponding Worksheet name. Each worksheet has either one table on it or no table at all. I'm looking to find a way to list the corresponding Table names in column C if one does indeed exist on that corresponding Worksheet. The part below was accomplished using this link: 3 Quick Ways to Get a List of All Worksheet Names in an Excel Workbook

Any help on this would be very much appreciated. Thanks, SS

1	2024
2	2023
3	2022
4	2021
5	2020
6	2019
7	2018
8	2017
9	2016
10	2015

 

[sspatriots]

Make sure that they have macros enabled.

Yep. I just came back to this to update. After going into Trust Center Settings and checking the box to enable Excel 4.0 macros it started to work for them. Thanks again.

 

[6StringJazzer]

My table started in cell A2.

I see. My confusion was from this:

the tables started at A1 (upper left corner)