I have been getting a reference (#REF) error on the worksheet when deleting a field. I can correct but I get an Type Mismatch error when I test for the #REF error using this code.
Code:
If Cells(OthEngRowDown + 1, 1) = CVErr(xlErrRef) Then ' Was a #REF! error was detected
Call GetTOD(CurRow, TODCol)
End If
[code/]
The cell that is being tested has a time format, "h:mm AM/PM" or just "h:mm" when the time exceeds 24 hours.
How can I test for the #REF error without getting a Type Mismatch error?
