VBA insert a formula into a cell

[Freakazoid]

I have a problem.

I want to insert the following into a single cell using VBA:

=if(M2<=K2;M2;0)

I have tried:

ActiveCell.Formula = "=IF(M2<=K2;M2;0)"

But gets an error:

Run-time error '1004':

Application-defined or object-defined error

[antoka05]

Try to change ';' with comma:

ActiveCell.Formula = "=IF(M2<=K2,M2,0)"

Regards,
Antonio

[Freakazoid]

Try to change ';' with comma:

Regards,
Antonio

It worked, Thanks alot for the help, I was stuck on this little problem, now i can go on.