Copying Array Formula

[gavs73]

Hi

Is there an easy way to copy and paste an Array formula ? ( simply copying and pasting doesn't appear to work ).

Thanks for your help.

Kind Regards
Gav

 

[Andrew Fergus]

Hi

What version of Excel are you using? In what way does it not appear to work? Is it a case of relative vs fixed cell references in the original formula that is causing the problem?

Andrew

 

[gavs73]

Hi, Excel 2003, it just returns errors, it doesn't recognise that they are array functions, I guess because it doesn't get the cntrl+shift+return to tell it they are array functions.

 

[Andrew Fergus]

Can you post the formula? If you copy the formula and re-confirm it by pressing F2 then Ctrl+Shift+Enter, does it make any difference?

A