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

13 votes248 views2 answers
Vba write text file
VBA
0 vote134 views1 answer
Vba copy file
VBA
0 vote123 views1 answer
Excel vba disable alerts
VBA
0 vote120 views1 answer
Handling a click event anywhere inside a panel vb
VBA
25 votes248 views3 answers
String to date vb
VBA
0 vote120 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote125 views1 answer
Excel vba prevent saving workbook
VBA
1 vote119 views1 answer
If inputbox cancel vba
VBA
0 vote76 views1 answer
Vba set vs dim
VBA
0 vote130 views2 answers
Do until loop vba
VBA