Error 1004 when pasting a long formula in Macro

I need to use a macro for a long formula but I keep getting a 1004 error when i try to use the Macro. The formula works fine when i enter it into a cell manually. When i click debug everything from "Selection.FormulaR1C1" to the end of the formula gets highlighted yellow.

Please Login or Register  to view this content.

I can't enter that formula by hand.
There seems to be something missing in your first line break
The first line ends with
R2C[
But the next line begins with
))*

So that would become R2C[))
Something is missing between [ and )

Can you post the actual formula you put in the cell by hand while you were recording the macro ?

=sqrt((((sqrt((j$2-j$3)^2+(l$2-l$3)^2))+(sqrt((j$2-a2)^2+(l$2-c2)^2))+(sqrt((j$3-a2)^2+(l$3-c2)^2)))/2)*((((sqrt((j$2-j$3)^2+(l$2-l$3)^2))+ (sqrt((j$2-a2)^2+(l$2-c2)^2)) +(sqrt((j$3-a2)^2+(l$3-c2)^2)))/2) -(sqrt((j$2-j$3)^2+(l$2-l$3)^2)))*((((sqrt((j$2-j$3)^2+(l$2-l$3)^2)) +(sqrt((j$2-a2)^2+(l$2-c2)^2)) +(sqrt((j$3-a2)^2+(l$3-c2)^2)))/2) -(sqrt((j$2-a2)^2+(l$2-c2)^2)))*((( (sqrt((j$2-j$3)^2+(l$2-l$3)^2))+(sqrt((j$2-a2)^2+(l$2-c2)^2))+(sqrt((j$3-a2)^2+(l$3-c2)^2)))/2)-(sqrt((j$3-a2)^2+(l$3-c2)^2))))

Please Login or Register  to view this content.

Here's the working code resulting from the Macro Recorder when I enter that formula by hand.

Please Login or Register  to view this content.

When i replace my formula with that I just get 0s. I think im just putting it in the wrong cell because of the difference in RC. But if it owrk by hand is the problem the copy and pasting?

It's going to depend on where you put the formula (i.e. what is ActiveCell or Selection)

The range references are all written with mixture of absolute and relative styles.
So it will end up different in J10 than it did in say G2.

So when you're using the macro recorder, make not of which cell you actually have active when you manually type the formula.
Then when you run the resulting macro, it has to put the formula into the same cell.

Is there a way I can paste the formula without having it cut off like shown in my first post so i dont have to do it by hand?

Just for future reference.

If you have a working formula in a cell and you want it in code, do as follows:

Select the cell with the working formula.
Developer, Record Macro, yes to the suggested macro name
F2
Enter
Developer, Stop recording.

Go to your macro that you just recorded and you'll see the formula in code.