CODE FOR VALUE >(NUMBER) AND

[navyaa]

I need to write an If condition where value of the activecell needs to be compared with a number(1999) and then another number(2051)

eg. IF Activecell > 1999 AND < 2150 then
call macro1
Else

I dont know the correct code for testing if the cell calue is between the two numbers.
Any help would be very appriciated

Navya.

 

[Andrew Poulsom]

Just repeat Activecell after AND.

 

[Juan Pablo González]

A method from Harlan Grove:

If Abs(ActiveCell.Value - 2074.5) <= 75.5 Then

End If