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

5 votes345 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote312 views1 answer
Move bindingnavigator vb
VBA
0 vote289 views2 answers
Delete all controls from list of control vb.net
VBA
3 votes296 views1 answer
Vba make long from two words
VBA
1 vote303 views1 answer
Excel vba to lower case
VBA
0 vote266 views1 answer
Vbnet check if string is only symbols
VBA
0 vote297 views2 answers
Excel vba copy paste after last row
VBA
0 vote294 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote287 views1 answer
Excel vba chrw max value
VBA
6 votes320 views1 answer
Excel vba get the path of current workbook
VBA