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 vote359 views1 answer
Enable macros on opening workbook vba
VBA
0 vote364 views1 answer
Average vba
VBA
0 vote377 views1 answer
Iterate all file in a folder vba
VBA
1 vote354 views1 answer
VBA Loop through recordset
VBA
15 votes497 views1 answer
Excel vba wait
VBA
22 votes574 views1 answer
Xl vba check for folder
VBA
0 vote365 views1 answer
Power query M substract minimum value of column -dax
VBA
-1 vote339 views1 answer
Text to speech vb.net
VBA
1 vote350 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote335 views1 answer
Hello world vb.net
VBA