Problems with VBA code to paste formula in cell

[robertguy]

Hi,

I’m trying to use a macro to paste the following formula (kindly supplied by Alkey in a previous post) i.e.

Please Login or Register  to view this content.

=SUMPRODUCT(--(P2:P1000="Met"),SUBTOTAL(103,OFFSET(P2:P1000,ROW(P2:P1000)-MIN(ROW(P2:P1000)),0,1)))

Please Login or Register  to view this content.

into a cell ’V1’ but I keep getting the error message :-

Compile error
Expected: end of statement

The syntax I am using is :-

Please Login or Register  to view this content.

Range("V1").Formula = "=SUMPRODUCT(--(P2:P1000="Met"),SUBTOTAL(103,OFFSET(P2:P1000,ROW(P2:P1000)-MIN(ROW(P2:P1000)),0,1)))"

Please Login or Register  to view this content.

Any assistance would be greatly revived

Many thanks in advance

Regards

rob

[jindon]

You need to double the double quotes within a formula string.

Please Login or Register  to view this content.

[robertguy]

Jindon

EXCELLENT,

many thanks


Regards


Rob