Wow, I just discovered the Name Manager. It is awesome but it seems like it is limited to selecting only one name (range) at a time. Is there a way to select multiple names (ranges) at one time?
If not…
Is there a way to paste the list of names in say column B on any work sheet and then when you would select a cell from column B that had a name in it, that cell would actually select the range the name refers to? Then you could hold down the Ctrl key and select multiple names (ranges)?
Note: all my ranges that my names refer to are rectangular…if that means anything to anyone.
If not…
Is there a way to paste the list of names in say column B on any work sheet and then when you would select a cell from column B that had a name in it, that cell would actually select the range the name refers to? Then you could hold down the Ctrl key and select multiple names (ranges)?
Note: all my ranges that my names refer to are rectangular…if that means anything to anyone.