The cell is returning the error:
"The formula in this cell differs from the formulas in this area of th
spreadsheet."

I was trying to duplicate our timesheet spreadsheet which is returnin
an "Inconsistent Formula" error, when adjacent Sum formulas differ i
range by one cell.

It looks like the code that you gave to me should have caught th
"differs" error as well.

Here is the code that I am using. Since I have not used thi
cabability before maybe I messed up someplace:

Sub FindIFerror()
If Application.ErrorCheckingOptions.InconsistentFormu la Then

With ActiveSheet
Range(Range("A1")
Range("A1").SpecialCells(xlCellTypeLastCell)).Spec ialCells(xlCellTypeFormulas
16).Select
End With

End If
End Sub

I am also wondering what exactly the "1004" error is telling me. I wa
assuming that it did not find an "error", but perhaps the range setup i
incorrect.

Thanks for your help

--
DougVb
-----------------------------------------------------------------------
DougVba's Profile: http://www.excelforum.com/member.php...fo&userid=3300
View this thread: http://www.excelforum.com/showthread.php?threadid=52833