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 vote219 views1 answer
Excel vba chrw max value
VBA
0 vote269 views1 answer
Excel vba protect sheet
VBA
0 vote230 views1 answer
How to format a textbox as date vb net
VBA
0 vote238 views1 answer
Windows Forms dark title bar
VBA
0 vote252 views1 answer
VBA
VBA
1 vote226 views1 answer
How to check is the value enterd is a number or text in vba
VBA
4 votes213 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote220 views1 answer
VB get external IP address
VBA
5 votes242 views1 answer
Excel-vba get integer high byte
VBA
0 vote226 views1 answer
Vbscript check if string is empty
VBA