thank you sir for you prompt reply but i doubt this will work only for a given column.
for eg : if i need this code to work on cells in column D only and other columns it should be normal. will this work

Regards
Skopweb