| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macros
pls post the formula that is not working
arno |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macros on one page | Excel Discussion (Misc queries) | |||
| calling a series macros with a marco | Excel Discussion (Misc queries) | |||
| Protect macros? | Excel Discussion (Misc queries) | |||
| Enabling macros | Excel Discussion (Misc queries) | |||
| Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Hybrid Mode
