VBA - Math Operators

Hi everyone,

I've got some code that runs through a column and checks to see if the number is < than the other one..

My problem is the fact that sometimes the criteria isnt always less than is there a way i can change the operator to a cell (value?) (I.e could be > or <)

Please Login or Register  to view this content.

Many thanks in advance!

Please Login or Register  to view this content.

COMPARE is some cell with < or >

File should now be attached.. Just click Go to week button, this will store the variable

I've put some fake data in, i've put the operator in col F and i've added some fake data in Col I (Actuals)

**Code is situated in the userform**

Thanks for your help!

Hi ProtonLeah,

Thank you for your response, do you know how i would go about it begin between a range?

Thanks!!