How aboutRange("A1:I9").SpecialCells(xlCellTypeBlanks).SelectThis will select the blank cells in a given range, no matter where/what theyare.