Hi Lawrence,

Try looking for the range name using Excel's Find featu select the 'Look
in: Formulas' option and uncheck the 'Find entire cells only' option.

---
Regards,
Norman



"Laurence Lombard" wrote in message
...
Any idea how one can find all the formulas in a workbook that use a
certain
named range.

In my case I have forgotten why I created a certain named range and would
like to know what will be affected if I delete it.

Thanks
Laurence