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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.