Thread: Test Message
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Test Message

iLastRow = Cell(Rows.Count,"I").End(xlUp).Row
For i = 1 To iLastRow
If Cells(i,"I").Value <0 or Cells(i,"L").Value < 0 Or _
Cells(i,"M") < 0 Then
MsgBox "Site balance on rfow " & i
End If
Next i

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Aaron" wrote in message
...
Hello All,

Looking for code that does the following.
Reviews cells I4,L4 and O4 If any of these cells are <0 andif any of the
same cells are 0 then Msgbox "Site Balance" else do nothing. Then next

row
and keep doing it until the end of page.

Thanks in advance!!
Aaron