I have inherited a complex spreadsheet with formulas all over the
place. The requirements are long gone. The original developers used
named fields to define cells referenced in the formulas. It's easy
enough to display all the formulas in one or all worksheets using the
Ctrl/~ keystroke combination. I would like to be able, once all
formulas are displayed and all worksheets are selected, to do a find
for each names field to find where it's used throughout the formulas
in the spreadsheet. Thus far I get a not found condition when doing
the find.

I could probably write a macro to spin the cells to see if I can find
named fields in the formulas but would need to test that. I know that
I can insert formulas into cells via a macro but haven't had the need
to look at the contents of formulas via a macro so don't know if this
could be done. As will every project in our exciting corporate world
my time frame is rather short and there are a lot of these named
fields.

Does anyone know how to do a find for data contained within the
formulas themselves? I am far too lazy to want to look at every
formula in every worksheet to see if these named fields are used but
will do so if that's how I have to proceed.

Hoping...

Thank you,
Jeff Jones