...I did the look at the workbook hence the question...
Looking at the workbook supplied, it appears the cells that were considered blank, were not blank, they had the text "---".
As this is the case, did you really look at the workbook as closely as you say you did?