Thread: Cell Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete[_4_] Pete[_4_] is offline
external usenet poster
 
Posts: 19
Default 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