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 vote334 views1 answer
Refer to resource using string variable vb.net
VBA
1 vote319 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote342 views1 answer
Excel vba calculate
VBA
1 vote325 views1 answer
Excel vba last row of range
VBA
0 vote345 views1 answer
VBA Loop to range
VBA
0 vote319 views1 answer
Vba format currency
VBA
3 votes313 views1 answer
Excel vba last row in range
VBA
0 vote396 views1 answer
Visual basic run command
VBA
6 votes376 views1 answer
Excel vba get the path of current workbook
VBA
8 votes393 views1 answer
Vba make integer
VBA