Aug 08 2021 02:50 PM
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.
Aug 08 2021 04:53 PM - edited Aug 11 2021 07:13 PM
@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:
Aug 08 2021 05:13 PM
Aug 08 2021 08:42 PM
SolutionAug 08 2021 08:42 PM
Solution