macro to check data against different ranges on different worksheets

  • Re: macro to check data against different ranges on different worksheets


    Now I am trying to apply the same code but each worksheet has different ranges. The code is below:



    Problem here is, when I give "k" a value lower than 2250, I get to see all the warning messages, not only the first one. Is there a way to make these commands active only if the command above does not hold the condition (for example check if X is out of the 2250 and 2810 range and if not go to the next one - otherwise stop there and give only the messge that there is no AM for the subject engine)?

  • Re: macro to check data against different ranges on different worksheets


    I have changed the code to below and it is working now.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!