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 vote367 views1 answer
Move bindingnavigator vb
VBA
0 vote358 views1 answer
Excel vba named range exists
VBA
0 vote334 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote406 views2 answers
Excel vba store array and write to sheet
VBA
1 vote324 views1 answer
Add a index column power bi
VBA
0 vote323 views1 answer
Get current url vb.net
VBA
0 vote304 views1 answer
Create new worksheet excel visual basic
VBA
8 votes423 views1 answer
Excel vba make a short integer from two bytes
VBA
2 votes321 views1 answer
Excel vba check if key is in collection
VBA
1 vote332 views1 answer
Vba date to unix timestamp
VBA