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 vote233 views1 answer
Excel vba copy entire sheet paste values
VBA
4 votes245 views2 answers
Excel vba last column with data
VBA
0 vote279 views1 answer
Filesystemobject vba reference
VBA
0 vote239 views1 answer
Backspace key has stopped working visual studio
VBA
1 vote253 views1 answer
Change the first item in a queue vb.net
VBA
0 vote233 views1 answer
Xlbycolumns is not declared
VBA
0 vote214 views1 answer
Vbide vbproject reference
VBA
0 vote261 views1 answer
Vba random number
VBA
3 votes240 views1 answer
Vba folderexists
VBA
0 vote237 views1 answer
Vb net check if file exists
VBA