Find where a named range is referenced?

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hi,

I have a named range called 'RangesB' and can't remember if I need it or
if it us used anywhere in my workbook.

Is there any way to find out if & where this named range is used? i.e.
in what formulas/cells?

Any help greatly appreciated.....thanks, Jason
 
Try something like this:

From the Excel Main Menu:
<edit><find>
Find What: (enter your range name here)
Click the [Options] button to see...
Within: Workbook
Look in: Formulas
Click [Find All]

The lower section of the window will list all cells referencing that range
name.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
That's fantastic Ron...I couldn't see the wood for the trees. I'm
always using Alt+E+F and turning the 'Look in' option from Formulas to
Values when I'm just doing a quick search for a value. I just totally
forgot :-)

Thanks for the reminder....Regards,

Jason

Ron said:
Try something like this:

From the Excel Main Menu:
<edit><find>
Find What: (enter your range name here)
Click the [Options] button to see...
Within: Workbook
Look in: Formulas
Click [Find All]

The lower section of the window will list all cells referencing that range
name.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Jay said:
Hi,

I have a named range called 'RangesB' and can't remember if I need it or
if it us used anywhere in my workbook.

Is there any way to find out if & where this named range is used? i.e. in
what formulas/cells?

Any help greatly appreciated.....thanks, Jason
Click to expand...
Click to expand...
 
You're welcome....I'm glad I could help.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Jay said:
That's fantastic Ron...I couldn't see the wood for the trees. I'm always
using Alt+E+F and turning the 'Look in' option from Formulas to Values
when I'm just doing a quick search for a value. I just totally forgot :-)

Thanks for the reminder....Regards,

Jason

Ron said:
Try something like this:

From the Excel Main Menu:
<edit><find>
Find What: (enter your range name here)
Click the [Options] button to see...
Within: Workbook
Look in: Formulas
Click [Find All]

The lower section of the window will list all cells referencing that
range name.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Jay said:
Hi,

I have a named range called 'RangesB' and can't remember if I need it or
if it us used anywhere in my workbook.

Is there any way to find out if & where this named range is used? i.e.
in what formulas/cells?

Any help greatly appreciated.....thanks, Jason
Click to expand...
Click to expand...
Click to expand...
 
Back
Top