kevlray
Registered User.
- Local time
- Yesterday, 20:40
- Joined
- Apr 5, 2010
- Messages
- 1,046
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. :banghead:
With ActiveWorkbook.Names("TotalActions")
.RefersTo = "=AV1!$G5:$G8"
End With
Any suggestions will be appreciated. :banghead: