You could try Edit | Find | "RangeName" in formulas.
Rgds,
ScottO

"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
|
|