Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Dynamic Named Range
Is there an easy way to check the actual range being defined by a dynamic
named range? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Dynamic Named Range
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" kirjutas sõnumis news: ... Is there an easy way to check the actual range being defined by a dynamic named range? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Dynamic Named Range
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 wrote: Is there an easy way to check the actual range being defined by a dynamic named range? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Dynamic Named Range
Thanks guys. This means my dynamic range needs some tweaking.
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Dynamic Named Range
On Mon, 22 Feb 2010 02:38:54 -0800 (PST), Pete_UK
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 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Dynamic Named Range
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...@grandmashouseattheendoftheu niverse.org wrote: On Mon, 22 Feb 2010 02:38:54 -0800 (PST), Pete_UK 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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Named Range for a Chart | Excel Discussion (Misc queries) | |||
Dynamic Named Range | Excel Discussion (Misc queries) | |||
Dynamic Named Range | Excel Discussion (Misc queries) | |||
Dynamic named range & Offset | Excel Discussion (Misc queries) | |||
Dynamic Named Range | Charts and Charting in Excel |