your Name refers to a formula rather than just a Range reference, and Named
Formulae do not appear in the Names Box dropdown.
(they do appear when using Name Manager -
http://www.decisionmodels.com/downloads.htm )

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"michael.beckinsale" wrote in message
...
Hi Bob,

Thanks for respondind so quickly, l think you had a typo, did you mean
dynamic ranges DO NOT appear in the dropdown?

Regards

Michael