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 vote244 views1 answer
Excel vba protect scenarios
VBA
0 vote215 views1 answer
Check range is in another range vba
VBA
0 vote215 views1 answer
Vba createparameter null
VBA
0 vote228 views1 answer
Vba pass named range to function
VBA
0 vote236 views2 answers
Excel vba number format file size
VBA
22 votes525 views1 answer
Xlvba check for folder
VBA
0 vote218 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote221 views1 answer
Vbscript abs
VBA
1 vote227 views1 answer
How to check is the value enterd is a number or text in vba
VBA
5 votes249 views1 answer
Excel vba tool to help with refactoring code
VBA