Hi All
I am trying to replicate this simple formula =IF(AND(L15="Yes", M15="Yes", N15="Yes"),"OK"," ") that works fine in Excel, but cannot get it to work in VBA
ActiveCell.FormulaR1C1 = "=IF(AND(RC[-6]=""Yes"", RC[-5]=""Yes"", RC[-4]=""Yes""),""OK""", """")"
Range("R3").Select
Selection.AutoFill Destination:=Range(Cells(3, 18), Cells(row1 - 1, 18)), Type:=xlFillDefault
Does anyone have a suggestion?
I am trying to replicate this simple formula =IF(AND(L15="Yes", M15="Yes", N15="Yes"),"OK"," ") that works fine in Excel, but cannot get it to work in VBA
ActiveCell.FormulaR1C1 = "=IF(AND(RC[-6]=""Yes"", RC[-5]=""Yes"", RC[-4]=""Yes""),""OK""", """")"
Range("R3").Select
Selection.AutoFill Destination:=Range(Cells(3, 18), Cells(row1 - 1, 18)), Type:=xlFillDefault
Does anyone have a suggestion?