Hi,

thanks for both of your replies. I've tried both and it works out fine.
However, for mdmackillop's code, my screen kept on flashing and updating. I tried screenupdating with worksheet change but no avail. May i know how do i get rid of this?


Thanks