Excel: set a range by its name [SELF-RESOLVED]

[krtxmrtz]

I have this VBA code in a Excel spreadsheet:

Dim vTarget As range
Private Sub Workbook_Open()
    Set vTarget = Range("Sheet1!$B$3")
End Sub

Now, cell $B$3 has been assigned the name "Volume". I want to set the vTarget variable using the name "Volume" rather than the cell address. I've tried different syntax but always get some kind of error.

[krtxmrtz]

Dim vTarget As range
Private Sub Workbook_Open()
    Set vTarget = Range(ThisWorkbook.Names("Volume"))
End Sub

It wasn't that difficult after all.

[zaza]

Private Sub Workbook_Open()
    Dim vTarget As range
    Set vTarget = Range("Volume")
End Sub

That will also work.


zaza

[krtxmrtz]

Private Sub Workbook_Open()
    Dim vTarget As range
    Set vTarget = Range("Volume")
End Sub

That will also work.


zaza

Right, thanks for pointing out.