Dear all, i am getting below error while running "EnterFormula" macro. i need your assistance
Rum time error ‘1004’:
Application-defined or object-defined error
Sub EnterFormula()
With Sheets("iput6")
.Range("AC6").Formula = "=IF(AND(B6>=20,C6>=13),SUM(B6:C6),IF(COUNT(B6:C6)<>2,"",1))"
.Range("AD6").Formula = "=IF(AND(D6>=16,E6>=17),SUM(D6:E6),IF(COUNT(D6:E6)<>2,"",1))"
End With
End Sub
Bookmarks