Here is my macro:

n = Sheets("Global").UsedRange.Rows.Count - 5
Range("H" & n & ":N" & n) = "=SUMIF(A:A,""Chagnon,Gérard (7)"",C)"
Range("P" & n & ":V" & n) = "=SUMIF(A:A,""Chagnon,Gérard (7)"",C)"


Here is the result:

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?


Can someone tell me what I am doing wrong ???

Thank you

Fantomas