It's not a version issue.

Are you using the same example workbook that you posted?
Did you change the code in any way?
Did you put YES in column D; not "Y" or "Yes " ?