For a given ActiveCell in Excel how can VBA retu the Table Name that appears in the properties grouping that becomes visible when the Table Tools Design tab is activated. So for example in the immediate window:
?ActiveSheet.ListObjects(2)
Table3600
but if I select a cell (potentially within a table) I can't seem to find a property that will either retu the selected cell's containing table's name. I am trying to either store the retu value or to state that the current cell is not in a table.
TIA (This seems very fundamental yet I am nowhere)