Thanks for your prompt reply. I was really literally begging for someone to help me.

Anyway, tried your code and set lastrow to the reference you suggested. But there was a complie error : code mismatch.

Also, I would like to ask what does " SpecialCells(xlCellTypeConstants, 23)." mean? What does the 23 signify?

Thanks and best regards,
noobie