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 vote139 views1 answer
Rotate image by any angle vb.net
VBA
0 vote129 views1 answer
Make all controls in an area not visable vb
VBA
5 votes158 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote152 views1 answer
Vba round to 2 decimals
VBA
0 vote135 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote138 views1 answer
Excel vba saveas no prompt for overwrite
VBA
-1 vote124 views1 answer
Text to speech vb.net
VBA
0 vote131 views1 answer
Excel vba current folder
VBA
-1 vote158 views1 answer
Code for reading letters only in vb 6
VBA
27 votes261 views2 answers
Vba check if file exists
VBA