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 vote150 views1 answer
Excel vba disable mouse click
VBA
0 vote174 views1 answer
Excel vba round to whole number
VBA
0 vote144 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote168 views1 answer
Tester si une case est vide vba
VBA
0 vote161 views1 answer
Build an index all files of a FTP site
VBA
0 vote187 views1 answer
Vbnet check if string is only letters
VBA
0 vote163 views1 answer
Vba keep command window open
VBA
0 vote157 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote157 views1 answer
Excel vba linter
VBA
0 vote166 views1 answer
Power query M substract minimum value of column -dax
VBA