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
Bookmarks