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

2 votes183 views1 answer
Vba round number
VBA
0 vote131 views1 answer
How to make a if statement with vbs
VBA
0 vote232 views2 answers
Excel vba store array and write to sheet
VBA
0 vote182 views1 answer
VBA is form loaded
VBA
0 vote189 views1 answer
Excel named range sum
VBA
0 vote188 views1 answer
Add text to combobox drop down vb
VBA
0 vote211 views2 answers
S yyyy-MM-dd em vb net
VBA
5 votes211 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote187 views1 answer
Afficher un message d'erreur vba
VBA
8 votes201 views1 answer
Excel vba determine number of elements in a 1D array
VBA