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 vote251 views1 answer
Vba format string as cash
VBA
0 vote235 views1 answer
VBA Sort RossetaCode
VBA
0 vote240 views1 answer
Excel vba DisplayAlerts
VBA
0 vote224 views1 answer
Visual basic msdos
VBA
0 vote229 views1 answer
Internet explorer reference vba
VBA
0 vote250 views1 answer
Excel last used row
VBA
0 vote247 views1 answer
Find database connection string vb
VBA
0 vote195 views1 answer
How to sort datagridview in vb.net
VBA
0 vote224 views1 answer
How to get the value of optionbutton in vba
VBA
5 votes260 views1 answer
Excel vba last byte from INTEGER
VBA