Update Macro to auto capture cell range and table name

redhandler Sometimes I need the name and range in the workbook.

Addressing the table and then parse the formula is one way to do it.

G4 =Table1

F4 =MID(FORMULATEXT(G4);2;4711)

where 4711 just is high enough to get all the characters.

F2 parses the cell references;
=LET(table;Table1;
firstCell;INDEX(table;1;1);
lastcell;(INDEX(table;ROWS(table);COLUMNS(table)));
firstCellAddress;ADDRESS(ROW(firstCell);COLUMN(firstCell));
lastCellAddress;ADDRESS(ROW(lastcell);COLUMN(lastcell));
output;firstCellAddress & ":" & lastCellAddress;
output
)

.CurrentRegion is just fine and this gives similar possibilities without macros, eg if the table is moved from A1.