C
Code Numpty
Is there an easy way to check the actual range being defined by a dynamic
named range?
named range?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
and click OK - the named range will be highlighted.
Hope this helps.
Pete
C
Code Numpty
Thanks guys. This means my dynamic range needs some tweaking.
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
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
the name, or F5 then select the name ?
Pete