vba formula code error

[gamerosko]

Hi guys, I'm vba beginner and I struggle with sending formula via VBA into a cell.. getting run-time error 1004

ActiveCell.Formula = "=LEFT(TRIM(MID(A19952;SEARCH(""."";A19952)-2;99));SEARCH("" "";TRIM(MID(A19952;SEARCH(""."";A19952)-2;99)))-1)"

Actually this Formula works if I put it directly into excel

=LEFT(TRIM(MID(A19952;SEARCH(".";A19952)-2;99));SEARCH(" ";TRIM(MID(A19952;SEARCH(".";A19952)-2;99)))-1)

If I try to send via VBA something easy - like .formula = ""test"" , then this works.. so I guess there is problem somewhere in the formula ?

Thx, G.

 

[NotoriousPopol]

Did you try to record a macro while inserting this formula?

 

[gamerosko]

Did you try to record a macro while inserting this formula?

Thx bro - always, now I won't forget trying record before I ask... worked, as I see it used R1C1 coding