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.