IF a number is in between two numbers....

A

Andrew McLeod

Just a quick query...

IF activecell.value (is in between 0.99 and 1.01) THEN

What is the code for the (in between 0.99 and 1.01)?
 
D

Don Guillett

try
Sub inbetween()
If ActiveCell > 1 And ActiveCell < 5 Then MsgBox "hi"
End Sub
 
B

Bob Phillips

If Activecell.Value >= 0.99 And Activecell.Value <= 1.01 Then
...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top