View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.