Macros
 

How can I copy a ready formula in Excel into codelanguage for macros?

For shorter formulas (1 line (function) in Excel), it is possible to start
the recorder, activate the formula, and stop the recorder. Then the whole
formula is ready in code for macro. When I try to do this for a formula (4
lines), I get a message that the formula cannot be copied.

Macros
 

pls post the formula that is not working

arno

Macros
 

The formula is:

=ROUNDUP(IF(H16="..";"";IF(H16="...";VLOOKUP(M16;A REA1;VLOOKUP(F16;AREA11;2)+11)+IF(E16120;0;0);IF( H16="...";VLOOKUP(M16;AREA2;VLOOKUP(F16;AREA22;2)+ 10)+IF(E16120;0;0);VLOOKUP(M16;AREA3;VLOOKUP(IF(F 16<1000;F16;ROUND(F16;;-2));AREA33;2)+10;FALSE)*IF(F16<1000;1;ROUND(F16;-2)/100))));0)

arno skrev:

pls post the formula that is not working

arno

Macros
 

The formula is:

=ROUNDUP(IF(H16.....

I get a message that the formula cannot be copied.

me, too (XL 2002). I do not know a way around this, maybe sb. else.

arno