find if number is a match

[nikko50]

Trying to find if the number entered in the input box "num_cmp" is => Cells(i, 2) AND <= Cells(i, 3) ? So basically if "num_cmp" is with the range of the numbers in Cells(i, 2)) or Cells(i, 3)) or an extact match of Cells(i, 2)) or Cells(i, 3)) . should be easy but I'm stuck?


num_cmp = InputBox("Please enter number:")

Please Login or Register  to view this content.