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 vote154 views1 answer
Vbscript check if string is empty
VBA
0 vote160 views1 answer
Excel vba hide gridlines
VBA
0 vote160 views1 answer
Vba integer to double
VBA
0 vote162 views1 answer
Weekday vba
VBA
1 vote165 views1 answer
Vbs run
VBA
0 vote152 views1 answer
Get month number from month name vbnet
VBA
0 vote174 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote206 views2 answers
VB
VBA
0 vote165 views1 answer
VBA Sort RossetaCode
VBA
0 vote164 views1 answer
VBA
VBA