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 vote159 views1 answer
Vb run command
VBA
0 vote166 views1 answer
Excel web scraping
VBA
0 vote155 views1 answer
Prive sub enter clicked vb
VBA
5 votes173 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote137 views1 answer
Vba text to general
VBA
0 vote153 views1 answer
Vba change active sheet
VBA
15 votes199 views1 answer
Excel vba wait
VBA
0 vote136 views1 answer
Vba dropdown event
VBA
3 votes142 views1 answer
Excel vba make long from two shorts
VBA
0 vote148 views1 answer
Vba string start with
VBA