J J.E. McGimpsey Nov 2, 2003 #2 On way: Dim blank As Boolean blank = Application.CountA(Sheets("Sheet1").Cells) = 0