I have tried using vLookup, sumifs, etc to use structured references to lookup values from a table, but it is not working in specific cells. It works everywhere else but I cannot figure out why it is not working! I even tried to write a subroutine to turn it on with those specific cells. I have turned it off, saved the workbook, completely closed excel, opened it back up, turned it on, saved, and completely closed/reopened excel but it still isn't working. Here is the sub I tried but I can't find any information online as to why it is not working in specific cells. Thanks for your help.
Sub test() Range("M13:R16").Select With Selection Application.GenerateTableRefs = xlGenerateTableRefStruct End With End Sub