john316swan
Board Regular
- Joined
- Oct 13, 2016
- Messages
- 66
- Office Version
- 2019
- Platform
- Windows
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.
VBA Code:
Sub test()
Range("M13:R16").Select
With Selection
Application.GenerateTableRefs = xlGenerateTableRefStruct
End With
End Sub