Hi Greg,

Thanks for your reply.

Actually this solution I have already done but I am not allowed to use On Error.
Is there any property or any other kind of indication by which I can figure this out?