Range("C2").FormulaLocal = "=ET($A$1=""Non"";$B$1=""Non"")"
toto = "ET($A$1=""Non"";$A$1=""Non"")" Range("A1").Value = toto maformule = Range("A1").Value Range("C2").FormulaLocal = "=" & maformule
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFormula = cell.FormatConditions(1).Formula1 Formula = Right(Formula, Len(Formula) - 1) Range("IV1").Value = "=" & Formula
Formula = "=ET($I$153=""Non"";$I$151=""Non"")" Formula = Right(Formula, Len(Formula) - 1) Range("IV1").Formula = Formula
Formula = "=ET($I$153=""Non"";$I$151=""Non"")" Formula = Right(Formula, Len(Formula) - 1) Range("IV1").Formula = "=" & Formula
Formula = "=ET($I$153=""Non"";$I$151=""Non"")" Range("IV1").Formula1 = Right(Formula, Len(Formula) - 1) Range("IV1").Formula1 = "=" & Range("IV1").Formula1