[VBA] Routine will not accept my .formula statements

[NessPJ]

Hello all,

I'm trying to enter 2 formulas in a range of cells in my VBA routine but i keep getting Debug errors upon execution (Run-time error 1004: Application defined or Object defined error).

These are the lines of VBA i am trying to use:

    Range("K2").Formula = "=TIME(IF(Roundup(L2*24;0)+3>=24;23;Roundup(L2*24;0)+3);0;0)" 


    Range("I2").Formula = "=IF((HOUR(L2)+24)-(HOUR(K2)-1)>=Par!$B$32;30;(HOUR(L2)+24)-(HOUR(K2)-1))"

I can paste both formulas into a cell and they will work fine. Am i using some wrong syntax somewhere?

 

[smozgur]

Hello,

Replace semicolons with comma.

Your language settings is likely using semicolon as the parameter separator, but when you create a formula through VBA, you need to use comma.

Hope it helps.

Suat

 

[NessPJ]

@smozgur: Thanks for the quick response! This fixed it!
Can't believe i overlooked this.....

 

[smozgur]

@smozgur: Thanks for the quick response! This fixed it!
Can't believe i overlooked this.....

Glad to hear it helped!

Suat