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?