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 vote116 views1 answer
Vba exit while
VBA
0 vote120 views1 answer
Get month number from month name vbnet
VBA
0 vote128 views1 answer
Menus act like radio buttons vb.net
VBA
1 vote133 views1 answer
Change the first item in a queue vb.net
VBA
3 votes129 views1 answer
Vba make long from two words
VBA
0 vote121 views1 answer
Windows Presentation Foundation dark title bar
VBA
5 votes132 views1 answer
Xl vba double quotes in string literal
VBA
6 votes127 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote123 views1 answer
Excel vba show developer tab
VBA
2 votes121 views2 answers
Excel vba copy values range to another range
VBA