Prev: Reverse word
Next: i am using office 2007 how can i put in exel the numbers in arabic
From: Code Numpty on 22 Feb 2010 04:00
Is there an easy way to check the actual range being defined by a dynamic
named range?
From: Arvi Laanemets on 22 Feb 2010 05:36
Hi

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


Arvi Laanemets


"Code Numpty" <CodeNumpty(a)discussions.microsoft.com> kirjutas sõnumis news:
5A63CFF9-6F00-41B9-B4FE-36B51A3DC5CD(a)microsoft.com...
> Is there an easy way to check the actual range being defined by a dynamic
> named range?

From: Pete_UK on 22 Feb 2010 05:38
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?

From: Code Numpty on 22 Feb 2010 07:09
Thanks guys. This means my dynamic range needs some tweaking.
From: Lil Red Riding In The Hood on 22 Feb 2010 09:18
On Mon, 22 Feb 2010 02:38:54 -0800 (PST), Pete_UK <pashurst(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.
 |  Next  |  Last
Pages: 1 2
Prev: Reverse word
Next: i am using office 2007 how can i put in exel the numbers in arabic