How do I find a code in Excel

[Guest]

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.

 

[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

 

[Guest]

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))

 

[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 -

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

 

[Guest]

Thats excellent I found it.

Thankyou very much.

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