If function with Range.Value

[stimea]

I would like to write a macro, where if in the E column a value which is bigger then 1, write in the F columns a formula

Something like this.

Please Login or Register  to view this content.

But it isn't accept the

Please Login or Register  to view this content.

line.

"Runtime error 1004
Method 'Range' of object '_Worksheet' failed"

[TMS]

Please Login or Register  to view this content.

Regards, TMS