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 vote238 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote216 views1 answer
Vb.net change cursor to wait
VBA
0 vote211 views1 answer
Vba exit while
VBA
0 vote202 views1 answer
Quit excel with save changes dialog vb.net
VBA
1 vote232 views1 answer
Vba refresh pivot table
VBA
0 vote215 views1 answer
Vba type
VBA
5 votes248 views1 answer
Vba low byte from INTEGER
VBA
1 vote216 views1 answer
Textbox find and replace vb
VBA
31 votes276 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
1 vote213 views1 answer
Excel vba autofit
VBA