How do I select a discontinuous named range in Excel?

[perkin_warbeck]

I have a named range that is discontinuous. For example, 

discontinuous=Sheet1!$C$3:$C$4,Sheet1!$D$3:$D$5

(the actual range in my application is more complicated).

In VBA, I can easily select this range:

Dim discontinuous As Range
Set discontinuous = Range("discontinuous")
discontinuous.Select

I would like to be able to do the same thing efficiently in Excel. By "efficiently," I mean without all the clicking, shift clicking, control clicking, etc. Is it possible? It seems like something that should be possible to do in Name Manager.

[#2]

@perkin_warbeck  Excel's Name Manager could be used for this, just give that range of cells a custom name and refer to it in Excel's formulas (i.e. SUM(discontinuous)), check this:

Referring to cells using Name Manager in Excel  

[#3]

I know how to refer to a named range in a formula. I simply want to select the range for a copy or paste. In other words, I want to do the equivalent of

discontinuous.Select

Except I want to do it in Excel.

[#4 · Accepted solution]

I found the answer. In the name box, select the name. This automatically selects the range.

I expected to find a similar feature in Name Manager.