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 vote196 views1 answer
Excel vba protect scenarios
VBA
0 vote168 views1 answer
Type excel.application is not defined vb
VBA
12 votes323 views1 answer
Excel vba write string to text file
VBA
8 votes193 views1 answer
Run command pormpt in background windows
VBA
3 votes185 views1 answer
Excel insert blank row for value change in column
VBA
0 vote187 views1 answer
Vbs run with cscript
VBA
0 vote173 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote180 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote176 views1 answer
Excel vba ternary
VBA
0 vote180 views1 answer
Open file dialog in vb.net
VBA