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 vote264 views1 answer
Vba change active sheet
VBA
0 vote269 views1 answer
Winforms dark title bar
VBA
0 vote212 views1 answer
Add items to combobox vb.net
VBA
1 vote231 views1 answer
Vba login website
VBA
0 vote225 views1 answer
Vbnet check if sting contians symbols
VBA
1 vote229 views1 answer
Export datagridview to excel vb.net
VBA
0 vote250 views1 answer
Create new worksheet excel visual basic
VBA
0 vote231 views1 answer
Check if program is running vbnet
VBA
0 vote236 views1 answer
Vbnet round to nearnest thousand
VBA
4 votes209 views1 answer
Excel formula for last non-empty cell in a column
VBA