Very Small Error In Uniques arrangement Code, Need correction

Hi Friends,

I have face small problem with Unique arrangement Code. problem is existing text is erased and un necessary Text was created at D2 cell. may be its requires small correction in my code.

please find sample worksheet and please correct by modification.

Thanks.