Macros

[Guest]

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.

 

[arno]

pls post the formula that is not working

arno

 

[Guest]

The formula is:

=ROUNDUP(IF(H16="..";"";IF(H16="...";VLOOKUP(M16;AREA1;VLOOKUP(F16;AREA11;2)+11)+IF(E16>120;0;0);IF(H16="...";VLOOKUP(M16;AREA2;VLOOKUP(F16;AREA22;2)+10)+IF(E16>120;0;0);VLOOKUP(M16;AREA3;VLOOKUP(IF(F16<1000;F16;ROUND(F16;;-2));AREA33;2)+10;FALSE)*IF(F16<1000;1;ROUND(F16;-2)/100))));0)

arno skrev:

 

[arno]

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