vba change named range address

VasteMonde answered on May 6, 2021 Popularity 3/10 Helpfulness 2/10

answer vba change named range address

vba change named range address

Comment

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

Popularity 3/10 Helpfulness 2/10 Language vb

Source: stackoverflow.com

Tags: named range vba

Link to this answer
Share Copy Link

Contributed on May 06 2021

VasteMonde

0 Answers Avg Quality 2/10

vba change named range address

Contents

More Related Answers

vba change named range address

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.