Need to check all the values in the given range

[VasanthiDeenadayalan]

The request is to refer Column A and verify that the only values present are 0 - 36. I have attached the workbook with the values and code I wrote.

[TMS]

Not entirely sure how your code relates to your question, but this would loop through the values in column A.

Please Login or Register  to view this content.

You'll need to decide which sheet it should process and add in the code to do something constructive with the cells that are highlighted.