Check Dynamic Named Range

C

Code Numpty

Is there an easy way to check the actual range being defined by a dynamic
named range?
 
A

Arvi Laanemets

Hi

In Name Manager, activate 'Refers' To field for this name - according
worksheet is activated with actual range marked (dashed border).


Arvi Laanemets
 
P

Pete_UK

Press F5 (GoTo) and type the name in the box (or select from the list)
and click OK - the named range will be highlighted.

Hope this helps.

Pete
 
L

Lil Red Riding In The Hood

Press F5 (GoTo) and type the name in the box (or select from the list)
and click OK - the named range will be highlighted.

Hope this helps.

Pete
Click to expand...


ANY time you go to the box that one uses to name a range and type in an
existing range name, Excel 'jumps' you directly to that range, selected.
 
P

Pete_UK

Yeah, so what's quicker - Insert | Name | Define (XL 2003) then select
the name, or F5 then select the name ?

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Named Range formula without using OFFSET function 5
Dynamic Named Ranges 3
concatenate dynamic ranges 7
Autofill a dynamic range with a formula. 1
Dynamic Named Ranges - is this possible? 2
Creating a high performance dynamic name 2
Constructing Range Name calls with Concatenate 4
Multiple Dynamic Named Ranges across Columns 3

Top