This is because the Male or Female value only occurs in one cell in the entire sheet, not on each row.
Where did you see that? No attachment that I saw.

If true -- and I assume it is -- then that would make a difference to some of the code, but I still think IMHO the With / End With is better (or at least my preference)