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

[krtxmrtz]

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

It wasn't that difficult after all.