Hi
JE McGimpsey

The solution you gave to me is working. Thanks for that. You have actually
given me code in VBA. IS it possible for you to guide me to use same function
using macro and achieveing same result.

If you want I can forward you my excel sheet and you can let me know the
solution using macro

Thanking you in Anticipation!!