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