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 vote179 views1 answer
Ribbon show/hide
VBA
0 vote181 views1 answer
VB Error Code BC30201
VBA
1 vote169 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote170 views2 answers
Vba function return array
VBA
0 vote189 views1 answer
Selecttoken em vbnet e json
VBA
0 vote180 views1 answer
Excel vba hide columns
VBA
22 votes346 views1 answer
Excel vba check if directory exists
VBA
0 vote180 views1 answer
Excel named range sum
VBA
0 vote180 views1 answer
Excel vba first working day month
VBA
0 vote166 views2 answers
Excel vba prevent save
VBA