Test cell value between values

I am trying to test a cell value if it is within a set range of "61 thru 120" (example).

If the active cell value is ">= 61" and "<=120" then do some code.

Any help is appreciated.

Your after VBA syntax, yes?

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

VBA Noob

Andy, I had nearly identical code, it was my code for choosing a scenario that was failing.

VBA Noob, the Case method makes for cleaner code in my case!

Thanks to both!