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 vote341 views1 answer
Set datetimepicker value to null vb
VBA
0 vote334 views1 answer
Vba run command
VBA
0 vote326 views1 answer
Vba excel do not recalculate before save
VBA
0 vote342 views1 answer
Excel vba named range exists
VBA
1 vote336 views1 answer
Excel vba to lower case
VBA
0 vote322 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote324 views1 answer
VBA Loop to range
VBA
0 vote327 views1 answer
Find control with name vb
VBA
0 vote298 views1 answer
Excel vba open browser
VBA
0 vote350 views1 answer
Vba ternary
VBA