Hidden Formula 1

[modmac]

I have an existing work book that has a formula that I can't seem to find anywhere. The work book has 5 sheets.
The formula is "=multiplier(D61)". It is the "multiplier" that I can't find. The multiplier changes dependant on the value of another cell. I would like to change the value of the multiplier but I can't seem to located the the table or array it is drawing from. I have checked the protection of the sheets and nothing seems to be locked/hidden etc.. HELP??

 

[BenRowe]

It might be a user function. Alt + F11 brings up the VBA editor. If it is a user function, you should see it in there.

 

[macropod]

Hi modmac,

It might also be a function in a Add-In. You can check for that possibility via Tools|Add-Ins - if any are checked, see if unchecking them has any effect.

Cheers

 

[modmac]

Thank you guys, I have checked both of those options and neither was it. Any other ideas? Thanks

 

[xlbo]

If it is as you have written the formula then I cannot think of any other places to find it. Is it in the function list ? Go to a blank cell and click on the fx button and see if it is available there

Other than that, try named ranges

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

Check in defined names in case it is a Name function ( i.e. a defined name containing a formula that will return a value ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Zathras]

As BenRowe has posted, Alt+F11 brings up the VBA editor. If you are not familiar with the display, the function code could be there but you might have missed it.

Look on the left-hand side of the screen. There should be a small window with a title like "Project - VBAProject" -- if not, Select View, Project Explorer from the menu (or press Ctrl+R)

In that small window, expand the tree and see if there is an entry with a folder icon that says "Modules" If there is, then double-click on each (or the only) module name which will cause a window to open that will reveal the code. Look for a line like function multiplier(.....

If after all that you still can't find it, then look again at the possibility of an Add-In.

In both cases, you won't find "multiplier" displayed immediately. You will have to dig a little deeper.

 

[modmac]

Thank you Zathras you are right on. Thank you very much.