Problem changing cell formula in VBA

[Jupsu]

Hi,
I have assigned formulas to a table in excel side. I have a macro that should replace those formulas in said cells in case someone has changed them.
The code here seems unnecessarily complex but basically what it should do is replace the formula of cell with the same exact formula it already has at the moment, with Cells().Formula

There are 4 rows of these replaces and I had trouble with all of them at first. I noticed that I had to replace some semicolons ( with colons (,). By doing this, 3 out of 4 now seem to work.

There's a problem still with the lowest row. I've tried all kinds of combinations of colon and semicolon but I can't get it to work.

The whole code:

Please Login or Register  to view this content.

Simplified, all it really is:

Please Login or Register  to view this content.

Can someone help me with this?
Thanks

[romperstomper]

It should read:

Please Login or Register  to view this content.

[Jupsu]

I tried this, and i still get error 1004 (application-defined or object-defined error)

[romperstomper]

Just noticed your actual formula is wrong, as you have 4 argments to your IF function. What is the original cell formula?

[Jupsu]

The 7,5 is a decimal value. That's probably causing the problem but i don't know how to insert the value 7,5 there otherwise.

This is the copied code from cell
[CODE][/=[@Työtunnit]-(IF(WEEKDAY([@Pvm];2)>5;0;IF(ISERROR(MATCH([Pvm];Holidays[Pvm];0))=FALSE;0;7,5)))CODE]

[Jupsu]

The 7,5 is a decimal value. That's probably causing the problem but i don't know how to insert the value 7,5 there otherwise.

This is the copied code from cell

Please Login or Register  to view this content.

fixed earlier message

[romperstomper]

Oh, then it's:

Please Login or Register  to view this content.

[Jupsu]

Oh, then it's:

Please Login or Register  to view this content.

Ah, of course. Thank you very much, it works now!

[romperstomper]

Glad to help.