How do I find a code in Excel
 

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.

How do I find a code in Excel
 

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

On Apr 27, 1:12 pm, Terranoman
wrote:
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.

How do I find a code in Excel
 

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

"Pete_UK" wrote:

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

On Apr 27, 1:12 pm, Terranoman
wrote:
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.

How do I find a code in Excel
 

On May 14, 9:07 am, Terranoman
wrote:
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))



"Pete_UK" wrote:
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

On Apr 27, 1:12 pm, Terranoman
wrote:
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.- Hide quoted text -

- Show quoted text -

'code' could be referring to a named Range. Go to Insert-Name-
Define and see if there is a range called 'code' defined in there.

How do I find a code in Excel
 

Thats excellent I found it.

Thankyou very much.

"Edward" wrote:

On May 14, 9:07 am, Terranoman
wrote:
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))



"Pete_UK" wrote:
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

On Apr 27, 1:12 pm, Terranoman
wrote:
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.- Hide quoted text -

- Show quoted text -

'code' could be referring to a named Range. Go to Insert-Name-
Define and see if there is a range called 'code' defined in there.