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 vote364 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote403 views1 answer
Vba remove the first character of string
VBA
2 votes379 views1 answer
Vba file from path
VBA
0 vote460 views1 answer
Excel vba delete columns in range
VBA
0 vote384 views1 answer
Build an index all files of a FTP site
VBA
0 vote350 views1 answer
Le contrôle SpinButton (Toupie)
VBA
1 vote350 views1 answer
Excel vba make cell visible
VBA
0 vote406 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote378 views1 answer
Find control with name vb
VBA
0 vote376 views1 answer
Send text to clipboard vb.net
VBA