Dear Ron

i must say you are a Genious, and Thanks a lot for the Code you have given.

But one thing i have noticed that if the DV is in a Marged cell ( C6:D6 )
then the code didn't worked, (i've changed the code Range as C6:D6 also)

is it a programme difault or i'm doing any mistake.

once again thank you for the help


Regards

Rishi