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

0 vote167 views2 answers
Vba remove line breaks
VBA
0 vote165 views1 answer
Excel R1C1 mode
VBA
22 votes296 views1 answer
Xlvba check for folder
VBA
2 votes158 views1 answer
Excel vba check if key is in collection
VBA
0 vote147 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote155 views1 answer
Vbs exec hidden
VBA
1 vote171 views1 answer
Excel date to unix timestamp
VBA
0 vote155 views1 answer
Excel vba address not absolute
VBA
0 vote145 views1 answer
Remove frist letter from string vbnet
VBA
0 vote161 views1 answer
Vba full date format
VBA