It would be faster to use specialcells. Can you attach a small sample workbook