Dear Andy,

I really appreciate your efforts and thanks once again..

But I really am no good in VBA and therefore unable to do the coding..

This works like a treat..

THis is one-cell result..IF i had columnar values then I would need to put in a loop?

Regards
e4excel