So I have two macros. I want the first one to run if the value in cell A5 is between 101-125 (including 101 and 125). I want the second macro to run if A5 is 0. But, if a number other than 0 or 101-125 is entered, I would like an error message to pop up. I have found I cannot use data validation because it prevents the usage of the number zero.
I've been using the following code in the sheet code but it simply is not setup for the value range of 101-125 and I can't figure out how to get it to work:
-All advice is appreciated,
Please Login or Register to view this content.