Hidden Table in Excel Sheet

Hello,

i am trying to find out a sheet inside excel.

there is a forumula like this in a cell " =PriceResults(S3;W3;T3;X3;0) "

i am trying where this PriceResults is ?

Can anyone help me out, where this hidden sheet is ? Inside a macro, hidden sheets, hidden functions ?

i am at wits end, and couldnt find it.

Inside PriceResults there are some kind of formula, and Price Calculation etc....

I tried to look at macro's, there aint any macro's recorded.


Can anyone help me ?

It looks like a user-defined function. Go into the Visual Basic Editor and look for a code module either within this workbook or any add-in that is opened.

To go into the Visual Basic Editor, if you're using Excel 2003 or older, go in the Tools Menu and it's one of the options in the Macro sub-menu. Once in the editor, you will have a collapsible/expandable list of opened workbooks and add-ins and their components. Functions are typically in modules, which are components of a workbook, usually listed after the more 'traditional' components like worksheets.

Before you do anything, I suggest you save a backup copy of the workbook. If you're not fluent in VBA, you could easily render that function useless by trying to modify it. If the function is in an add-in, a back-up copy of the function itself would be a good idea.

Hope that helps,

Brigitte