Forum Discussion
Solved
How do I select a discontinuous named range in Excel?
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 se...
- 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.
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:
https://martinbosanacvba.blogspot.com/2021/08/referring-to-cells-using-name-manager.html
- 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.