Cell Value
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
|