I have an existing named range called TotalActions. But I want to use VBA code to change that range. But the code I have basically does nothing (i.e., the value for the named range TotalActions does not get modified). Everything I have found so far indicates that my code is correct.
.RefersTo = "=AV1!$G5:$G8"
Any suggestions will be appreciated.