VBA Excel ... Quota in string

[Jezoo]

Hello,
I have problem insert formula to sheet with using macro. I need insert this formula:
=SUMIF($F$2:$AZ$2;"TOTAL";F7:AZ7)

... and a write this code:
Cells(riadok, 5).Formula = "=SUMIF($F$2:$AZ$2;" & ""TOTAL"" & ";F" & riadok & ":AZ" & riadok & ")"

.. problem is text mark with red color.

Please help me. Thanks.

[royUK]

Is Total a variable?

Please Login or Register  to view this content.

[antoka05]

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[Jezoo]

Thanks ... I use this code:

Please Login or Register  to view this content.

[royUK]

What is TOTAL referring to?

[Jezoo]

... TOTAL is only caption of column where I check when data with this column get to SUM.