True or False if Number Lies Between a Certain Value

I have an Excel workbook which has 10 rows of numbers with a min of 20 and max of 30. The random number lies in column B and this will be tested to see if it lies between the min and max. I need to loop this 10 time over

I first started out declaring the 3 variables and assigning values to each variable. It works if I assign a value of 22 for Number but I want VBA to see the Number and make a decision (True or False) if that number lies within the range of 20 to 30.

Should I name the Number variable as a variable because its value will change depending on if it matches the conditions? Also would a case be easier? Between.xlsx

Here is what I have so far

Please Login or Register  to view this content.

Hi AtomicDog

Do you really want Code?

This Formula in E2, drag down appears to do as you require

Formula:

Please Login or Register  to view this content.

Originally Posted by jaslake

Hi AtomicDog

Do you really want Code?

This Formula in E2, drag down appears to do as you require

Formula:

Please Login or Register  to view this content.

You're right, it doesn't require code but I'm trying to learn VBA and the basics. Even though your suggestion didn't directly lead me to the answer, it gave me the idea to use the macro recorder to use the AND statement on Excel to see what the code will be.

I'm posting the code below, would you mind telling me what some of the lines mean? Why put R1C1 after formula? Why use RC[-8]?

Please Login or Register  to view this content.

Hi AtomicDog

Good for you...need further help, let me know.

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save