software

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)?

try
Sub inbetween()
If ActiveCell gt; 1 And ActiveCell lt; 5 Then MsgBox quot;hiquot;
End Sub

--
Don Guillett
SalesAid Software

quot;Andrew McLeodquot; gt; wrote in message
...
gt; Just a quick query...
gt;
gt; IF activecell.value (is in between 0.99 and 1.01) THEN
gt;
gt; What is the code for the (in between 0.99 and 1.01)?
If Activecell.Value gt;= 0.99 And Activecell.Value lt;= 1.01 Then
...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Andrew McLeodquot; gt; wrote in message
...
gt; Just a quick query...
gt;
gt; IF activecell.value (is in between 0.99 and 1.01) THEN
gt;
gt; What is the code for the (in between 0.99 and 1.01)?