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. Possible return values are xlGenerateTableRefA1, xlGenerateTableRefStruct.


Application.GenerateTableRefs = xlGenerateTableRefA1