Use of "if-and" structures within a loop

Hi all,
I have defined the following logical sentence: =IF(AND(LEN(A1)=6);ISNUMBER(A1)) This will return either TRUE or FALSE. What I struggle with is to use this as a filter criteria in a vba loop. So, my question to you is: can you construct a loop in VBA which makes use of the above logical sentence and that highlights the observations (in a range) that is TRUE? This without inserting the formula and/or making TRUE/FALSE visable in Excel - I just need it a s a filter rule which will highlight the ones that is TRUE. Start Free Trial