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 vote220 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote191 views1 answer
Excel run macro every 5 minutes
VBA
0 vote216 views1 answer
Vbnet check if string is only letters
VBA
0 vote195 views1 answer
Vba array of integers
VBA
0 vote171 views1 answer
Docker vboxmanage not found
VBA
3 votes186 views1 answer
Vba not equal
VBA
0 vote208 views1 answer
Excel filter by date not working vba
VBA
31 votes390 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote183 views1 answer
Excel vba existence of a file
VBA
0 vote184 views1 answer
Excel vba assign shortcut key to button
VBA