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 vote205 views1 answer
Vbs
VBA
5 votes198 views1 answer
Excel vba how to unit test vba code
VBA
0 vote203 views1 answer
.net dark title bar
VBA
0 vote238 views1 answer
Programmatically copy data from one workshet to another excel
VBA
6 votes213 views1 answer
Excel vba check if a string only contains letters
VBA
1 vote238 views1 answer
Excel vba get column number from column name
VBA
0 vote214 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote234 views1 answer
Vba integer to double
VBA
0 vote226 views1 answer
Vba parameter adodb null value
VBA
0 vote211 views1 answer
Vbnet line graph smooth lines
VBA