Validation specific characters in a string of characters

Hi Everyone,

Is there a VBA way to validate if certain characters in a string of characters have specific values. For instance, take the following string:

07001362CA39DN7000002269 20140810 000099999999

Say I want to verify if characters 23 and 24 ("69") are between "67" and "71" , and if they are not, to change their color to red.

Thanks guys!

That's very helpful Thanks!

Any thoughts on why If I try to change to the range for say Set C = Range("A:A") or Set C = Range("A11:A30") , I get a type mismatch error?

Thanks

Yes, because this code is designed to look at one cell at a time. What are you trying to accomplish by changing it to a range? Do you want to limit which cells are included in this check, rather than do it for any cell on the sheet? How are you using the macro?