I have a boolean array and I want to check to see if it contains at least one set of 7 consecutive elements that are set to False.
My plan is to convert it to a string of '1' and '0' characters and use InStr to search for "0000000".
I'm stuck because I can't work out a way of doing the conversion.
Obviously I could do a For loop and build the string but I'd like to do it all in one line.
Anybody up to the challenge?
