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 vote218 views1 answer
Excel vba prevent saving workbook
VBA
4 votes202 views1 answer
Excel vba check cell not empty
VBA
0 vote220 views1 answer
Vba array dimensions
VBA
0 vote201 views1 answer
Vba like with wildcard
VBA
0 vote210 views1 answer
Vba get application version
VBA
0 vote219 views1 answer
Excel vba textbox forecolor disabled
VBA
3 votes201 views1 answer
Vba folderexists
VBA
0 vote248 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote208 views1 answer
Vbnet find highest value in chart
VBA
0 vote247 views1 answer
Vba foreach 2d array
VBA