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

Pete

On Feb 22, 2:18 pm, Lil Red Riding In The Hood
<lilredridingintheh...(a)grandmashouseattheendoftheuniverse.org> wrote:
> On Mon, 22 Feb 2010 02:38:54 -0800 (PST), Pete_UK <pashu...(a)auditel.net>
> wrote:
>
> >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
>
> >On Feb 22, 9:00 am, Code Numpty <CodeNum...(a)discussions.microsoft.com>
> >wrote:
> >> Is there an easy way to check the actual range being defined by a dynamic
> >> named range?
>
>   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.