All perfect praise be to Allaah, The Lord of the Worlds. I testify that there is none worthy of worship except Allaah, and that Muhammad, sallallaahu ‘alayhi wa sallam, is His slave and Messenger.
First of all, it should be noted that the Sunnah of the Prophet is that he married women. He said: “...and I marry women, and whoever desists from my Sunnah, he is not one of us.” [Al-Bukhari and Muslim] Furthermore, he very much urged young people to marry as he said: “O young people, whoever is able to marry should marry.” [Al-Bukhari and Muslim]
As regards refusing to marry, the Prophet disliked it, as in the story of ‘Uthmaan ibn Math’oon . Moreover, we do not know any authentic narration about the excellence of not marrying at the end of times. It is true that some narrations have been reported in this regard, but As-Sakhaawi said that all of them are weak.
In fact, some scholars ruled such narrations to be fabricated, like the narration: “The best amongst you in the coming two centuries is the one who has no wives and no children.” [Abu Ya’la]
For more benefit, please refer to Fatwa 84077.
Finally, you should know that Haroun Yahya is not a religious reference so that people take religious rulings from his words, and that he himself does not claim to be so.
Allaah Knows best.