Vba change named range address

Dim wb As Workbook
Dim nr As Name

Set wb = ActiveWorkbook
Set nr = wb.Names.Item("myRange")

' give an absolute reference:
nr.RefersTo = "=Sheet1!$C$1:$C$9"

' or, resize relative to old reference:
With nr
    .RefersTo = .RefersToRange.Resize(100, 1)
End With

Source: stackoverflow.com

Similar codes

1 vote150 views1 answer
Excel vba last row of range
VBA
0 vote144 views1 answer
Excel vba hide gridlines
VBA
0 vote141 views1 answer
Send webhook vbscript
VBA
3 votes137 views1 answer
Excel vba read registry key value
VBA
0 vote141 views1 answer
Freeze panes vba
VBA
2 votes159 views2 answers
Excel vba if sunday or staurday
VBA
0 vote152 views1 answer
Vba horizontalalignment
VBA
0 vote150 views1 answer
Vba keep command window open
VBA
0 vote151 views1 answer
.net crash app
VBA
0 vote136 views1 answer
Vbs exec hidden
VBA