recording macro to paste a copied ws formula

[Peter]

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

 

[Ron de Bruin]

Hi Peter

I don't see your code but if you use
activecell.Formula = ...........................

Then use a , instead of ; in the VBA code (VBA = US)
It will change it to ; when you open it in a Duch version

 

[Ron de Bruin]

Hi Peter

After a private mail I understand your situation.

Here is the problem
http://support.microsoft.com/default.aspx?scid=kb;en-us;212172