How to find all formulas that used a certain named range

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

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

"Laurence Lombard" <lombardm@mweb.co.za> wrote in message
news:4ZednSu0Gv5VUcDenZ2dnUVZ_s-dnZ2d@is.co.za...
| 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
|
|

Hi Lawrence,

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

---
Regards,
Norman



"Laurence Lombard" <lombardm@mweb.co.za> wrote in message
news:4ZednSu0Gv5VUcDenZ2dnUVZ_s-dnZ2d@is.co.za...
> 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
>
>