title: VBA Check if cells of a row consist of same text continously
body: <p>i have a row of 24 cells having value Null and "ON". i  want to write a macro to  check this row if it contains 2 block of 6 "ON" continuously. Please help</p>