Hi AB33

Thanks for the solution. It is working fine but its too slow for 50,000 records.
Same question I have asked in this http://www.excelforum.com/excel-form...test-date.html .
So we will discuss in that thread