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 vote252 views1 answer
Excel vba protect worksheet without password
VBA
4 votes192 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote212 views1 answer
VB Error Code BC30201
VBA
0 vote202 views1 answer
Vba len variant
VBA
0 vote213 views1 answer
Vba collection contains
VBA
0 vote203 views1 answer
Vba boolean to string
VBA
0 vote190 views1 answer
Style percent not found vba
VBA
0 vote220 views1 answer
Vbscript check if string contains
VBA
0 vote211 views1 answer
Excel vba automatic calculation
VBA
0 vote211 views1 answer
Vba array dimensions
VBA