Thread: Greater than, less than statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Greater than, less than statement
If x 500 And x < 999 Then
MsgBox ("IN THERE")
End If
--
Gary's Student
gsnu200706


"DP7" wrote:

I have a nested if statement, I am trying to write, if a1 greater than 500
but less than 999, then do X. I cant seem to get that part to work. Any
Ideas ???
Thanks

Reply With QuoteReply With Quote