Object defined error with Cells.Formula

[Jupsu]

Hi
I can't figure out why I'm getting object defined error with Cells.Formula on the last row but not on the one above it.
Using a table [WorkDays] and changing formulas of the last row. Formula = "=[@Pvm]" works but the largest one doesn't

there are plenty of columns in the table, including all the ones named in the formula. The formulas are copied from the current ones in the table so shouldn't be a problem there?

Please Login or Register  to view this content.

[Jupsu]

note: I have a lot of these .formulas in the code, some work and some dont

[Jupsu]

I figured it out. If anyone else is having this problem, you should know that against all logic you have to replace ; with , even though it's inside " "

[Jupsu]

NEW PROBLEM:

Why does this row not work?

Please Login or Register  to view this content.