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 vote244 views1 answer
How to remove zeros in excel
VBA
31 votes538 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote242 views1 answer
Vb run command
VBA
0 vote236 views1 answer
Vba sheet visible
VBA
0 vote244 views1 answer
Vba listbox remove all items
VBA
1 vote234 views1 answer
How to put a gridpain in a vbox
VBA
0 vote245 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote228 views1 answer
Excel vba disable screen update
VBA
1 vote243 views2 answers
Excel vba password protect
VBA
0 vote221 views1 answer
Excel vba show developer tab
VBA