I have the following code that at times gets the "error13 type mismatch message" when I open the sheet
Private Sub Worksheet_Calculate()
If Range("O15") <> "" Then
If Range("Q17").Value = "yes" Then
Range("O19") = Range("O15")
Range("O20") = Range("q20")
Range("P19") = Now
End If
End If
If Range("Q25").Value = "yes" Then
Range("O19") = ""
Range("O20") = ""
Range("P19") = ""
End If
End Sub
As a result Excel gets into debugging mode at the first line of the code. Today it looks it makes not work the Sub_auto Open in one of the sheets. Anyone any idea what is going on????!!
Cheeers
BC
Bookmarks