Hi everybody,
I have a few code lines and i don't know what it doesn"t work.
the value of strValSUmMonth is for exemple =SUMIF(Z34:AC34;"OK";Z3:AC3)Dim strValSumMonth As String strValSumMonth = "=SUMIF(" & Cells(i, j).Resize(, 4).Address(False, False) & ";" & Chr(34) & "OK" & Chr(34) & ";" & Range(strAdresseOKpasOk).Resize(, 4).Address(False, False) & ")" Cells(i, j).Offset(0, 5).Value = strValSumMonth
the bug here is in the last code line.
Any help please ?