How do I find a code in Excel

T

Terranoman

I have been left a spreadsheet with has a formula linked to a 'code'. Is
there any way of locating or 'recalling' the code which presumably been
assigned with Ctrl, Shift, Enter?

Any help greatly appreciated.
 
P

Pete_UK

What do you mean by 'code' - is there a macro or User-defined function
in there?

Ctrl-Shift-Enter is used to set up an array formula, and if you think
there are any in your worksheet then you will see curly braces { }
around the formula when viewed in the formula bar.

The word CODE is a valid function in Excel.

Post back with a bit more explanation of your spreadsheet and problem.

Hope this helps.

Pete
 
T

Terranoman

An example of the code for the array is:

=IF(B339="","",SUMPRODUCT( ( LEN( B339) - LEN( SUBSTITUTE( LOWER( B339),
LOWER( Code), "" ) ) ) / ( LEN( Code) + ( LEN( Code ) = 0 ) ), load))
 
E

Edward

An example of the code for the array is:

=IF(B339="","",SUMPRODUCT( ( LEN( B339) - LEN( SUBSTITUTE( LOWER( B339),
LOWER( Code), "" ) ) ) / ( LEN( Code) + ( LEN( Code ) = 0 ) ), load))









- Show quoted text -
Click to expand...

'code' could be referring to a named Range. Go to Insert->Name-
 
Top