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 vote131 views1 answer
Excel vba prevent saving workbook
VBA
0 vote127 views1 answer
Vbs send keys
VBA
0 vote131 views1 answer
Vba file chooser
VBA
0 vote137 views1 answer
Vbnet round to nearnest thousand
VBA
4 votes142 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
1 vote143 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote133 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote129 views1 answer
Telephon call in vba
VBA
1 vote133 views1 answer
Vbs run
VBA
1 vote123 views1 answer
Excel vba get ordinal number from cardinal number
VBA