"Myrna Larson" wrote in message
...
Huh? Do you mean that all of the cells in A2:A7 aren't filled

That's the inference of the original question, AFAI can tell. A2:A7 *can*
contain a group of non-contiguous cells, eg: A3, A5, A7.