Application.GenerateTableRefs (Excel)

The GenerateTableRefs property determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas.

xlGenerateTableRefA1, xlGenerateTableRefStruct.
Application.GenerateTableRefs = xlGenerateTableRefA1
Application.GenerateTableRefs procedure builder