Forum Discussion

perkin_warbeck's avatar
perkin_warbeck
Brass Contributor
Aug 08, 2021
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...
  • perkin_warbeck's avatar
    Aug 09, 2021
    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.

Resources