Hello everyone,

Using the macrorecorder to record the pasting of a copied worksheetformula
into a cell seems to cause a problem for a ws-formula that has, in this
case, 252 characters. (Dutch MS-Office-Excel 2003/XP Home Dutch)

Is there a way to have vba code insert such a long worksheetformula into a
cell?

For all intents and purposes I hereby give you the formula as is when the
worksheet containing it is opened in the English version of MS-Office-Excel
XP):

=IF(ISERROR(IF(LEFT(id_projectie;4)="oud:";0;ROUND (SUM(D3:OFFSET(INDIRECT(E1
9);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2)));"";IF(LEFT(id_projectie;4)="oud:
";0;ROUND(SUM(D3:OFFSET(INDIRECT(E19);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2)
))

The dutch words in this formula translate to:
IF ALS
ISERROR ISFOUT
LEFT LINKS
ROUND AFRONDEN
OFFSET VERSCHUIVING

Thanks for your help

Peter