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 vote169 views1 answer
Random number generator vb.net
VBA
31 votes312 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote160 views1 answer
Vba get relative cell address
VBA
1 vote188 views1 answer
Vb.net get name by Cell Click
VBA
0 vote173 views1 answer
Remove first character from string vb
VBA
0 vote185 views1 answer
Delete all controls in an area vb
VBA
0 vote159 views1 answer
Quit excel with save changes dialog vb.net
VBA
4 votes181 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote170 views1 answer
Discern between file and folder given path vb.net
VBA
2 votes121 views2 answers
Vba exit loop
VBA