Thanks shg for notifying me about the response time, I have joined excel forum hours back and i have seen this thread as soon i joined, so i replied what i have tried in VBA and what i know. i did't see the time of question when it was posted.