The actual data starts on row 4, where I started my loop. Before that there is a merged row 1&2 sheet name and row 3 is headers. There are no unusual characters, I have triple checked it now after finding some odd balls the first time through. A couple were formatted as text (left justified and had a little green triangle), I fixed them. Every single cell in that column is a date mm/dd/yyyy format. There are no more blank ones either.