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 vote314 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote336 views1 answer
Excel vba set cell value to empty
VBA
0 vote335 views1 answer
Excel vba add reference programmatically
VBA
1 vote304 views1 answer
Excel vba autofit
VBA
0 vote348 views1 answer
Excel vba convert cells address
VBA
0 vote305 views1 answer
Excel vba delete folder
VBA
5 votes317 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote279 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote294 views1 answer
Vbnet dynamically change excel sheet name
VBA
20 votes451 views1 answer
Excel vba factorial
VBA