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

3 votes300 views1 answer
Excel insert blank row for value change in column
VBA
2 votes279 views1 answer
Date format for ms chart vb.net
VBA
1 vote278 views1 answer
Highlight selected cell in excel vba
VBA
0 vote286 views1 answer
Vbscript check if string contains
VBA
0 vote409 views1 answer
Vba change active sheet
VBA
1 vote245 views1 answer
Vba exit do while
VBA
0 vote303 views1 answer
Excel vba clear filter
VBA
0 vote280 views1 answer
Refresh token em vb net
VBA
0 vote301 views1 answer
Loop through all text boxes in a form vb
VBA
1 vote257 views1 answer
How to open cmd with vbd
VBA