Thread
:
Dynamic Range
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Dynamic Range
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett