Cell Value

Tech-Archive recommends: Fix windows errors by optimizing your registry

I use the code below to check to see if the minutes in a day total
1440, for some reason, I am getting the MsgBox telling me that C56 does
not equal 1440. I have physically checked this, and can see the value
1440 in C56 from the formula =SUM(C55,D55)

If Sheets("Sheet1").Range("C56").Value <> 1440 Then
MsgBox ("Please Check You Planned Running Time, it does not add up
to 1440")
Exit Sub
End If

Any ideas?

Thanks

Pete

.

Quantcast