VBA macro to put Formula in cell - too long?

Hi,

When I try to run the below code (it should copy the formula into the cell) I get the error message "Run-time error '1004': Application-defined or object-defined error".

Is this because it is too long? If so, how could I shorten it?

Thank you in advance for your help!

Please Login or Register  to view this content.

You have mismatched parentheses, I think. I also don't see the purpose of the VALUE function if you are checking against a string, so try:

Please Login or Register  to view this content.

Please don't forget to mark the question 'Solved'.