Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How to find all formulas that used a certain named range
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 | | |
#3
|
|||
|
|||
How to find all formulas that used a certain named range
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find all named ranges in VB.NET? | Excel Discussion (Misc queries) | |||
Find last occurance of text in range | Excel Worksheet Functions | |||
Using a formula to create named range reference | Excel Worksheet Functions | |||
Find cell contents in range | Excel Discussion (Misc queries) | |||
Use MATCH to find position of max in 2D range? | Excel Worksheet Functions |