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 vote171 views1 answer
Hello world vb.net
VBA
0 vote179 views1 answer
Vba word pdf table to excel
VBA
0 vote165 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote176 views1 answer
Vba timestamp -- milliseconds
VBA
-1 vote162 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote178 views1 answer
How to use if condition in time vba
VBA
1 vote183 views2 answers
Vba string length
VBA
0 vote167 views1 answer
Vba collection key list
VBA
0 vote181 views1 answer
Open file dialog in vb.net
VBA
3 votes171 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA