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 vote282 views1 answer
Excel vba unlock sheet without password
VBA
5 votes306 views1 answer
Excel vba right word from Long Integer
VBA
0 vote306 views1 answer
Windows Forms dark title bar
VBA
0 vote271 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote265 views1 answer
Vba line feed
VBA
0 vote289 views1 answer
Vba open report
VBA
0 vote287 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote269 views1 answer
Vbscript check if string contains
VBA
0 vote283 views1 answer
Excel vba protect worksheet without password
VBA
3 votes297 views1 answer
Excel vba make long from two shorts
VBA