How do I specify a range in the do until loop in VBA?

How do I specify a range in the do until loop in VBA?

I'm writing a code, so that
Do Until Range("A1:A10")=5
""
Loop
I want a certain range to all have the same numbers, but VBA keeps on
telling me there's a type mismatch. It seems that you can only work with
one cell at a time or you would have to use the "And" function? (Do Until
Range("A1")=5 And Range("A2")=5 , etc.) But is there a way to have the
loop run until a certain range of cells satisfies the condition? Thanks!