About Us

Don Guillett

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sandy" wrote in message
...
It was in my head there was a way to do it - Thanks
Sandy

"Don Guillett" wrote in message
...
Defined named ranges do NOT show. you may goto the name box and type in
the name and see the selection.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sandy" wrote in message
...
I have created a dynamic range named "Result1" using the following
formula

=OFFSET(dBase1!$G$31,,,dBase1!$A$29,19)

Why does this named range not show up in the "Name Box"?
Is there any way I can have it highlight to satisfy me that it is indeed
covering the range I require?
Sandy

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic range	Frank Situmorang	Excel Worksheet Functions	4	May 7th 07 03:30 AM
Dynamic range	prakash	Excel Discussion (Misc queries)	2	September 11th 06 12:24 PM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
Dynamic range - is there a better way?...	Jon	Excel Worksheet Functions	0	November 9th 05 08:09 PM
help with dynamic range	Shanin	Charts and Charting in Excel	1	September 1st 05 09:58 PM