Re-setting named range

[kray4660]

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.

With ActiveWorkbook.Names("TotalActions")
.RefersTo = "=AV1!$G5:$G8"
End With

Any suggestions will be appreciated.

 

[kray4660]

Found out some further information. It appears my code sorta works. I tried a different range and it did change the range, but it is offsetting the rows by four rows. i.e., I set the range to A1:A5 and it shows the range as A5:A9. I have no idea why.

 

[strongm]

Looks OK - and works OK here ...

 

[kray4660]

Figures that Excel is being odd.

 

[kray4660]

Not sure, but it appears it was doing an offset from a active cell. When I set the active cell to A1, it appears to be working correctly now.