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 vote211 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote222 views1 answer
VBA Loop to range
VBA
3 votes218 views1 answer
Vba not equal
VBA
0 vote193 views1 answer
Vba code to open a file with login rights
VBA
1 vote215 views1 answer
Vbscript convert ascii code to character
VBA
0 vote208 views1 answer
VBA Sleep Snippet
VBA
0 vote218 views1 answer
Vba collection contains
VBA
0 vote208 views1 answer
Vba full date format
VBA
0 vote246 views1 answer
Vb ternary
VBA
0 vote220 views1 answer
Vb run command
VBA