try Range("c2").ClearContents.





"Tiya" wrote in message
...
Hi to All
I have filed like CodeNo.,ItemName,PartyName,Wt,Descrp.

I have codeno. more than 3000 which is fix like c1to c300,b1tob300 ps1 to
ps250
etc... I have to delete every time when perticular codeno. item is sold
but
not the codeno. ie. to delete all ItemName,PartyName,Wt,Descrp.only.

When i want to delect c2, c45, b30 etc.. it should ask my code no. and
when
i enter codeno it should delete than codeno. infromation like
ItemName,PartyName,Wt,Descrp.only and when i want to enter than codeno it
should first ask blank codeno. and add
data into than rows

I done have anyprog. code for this. i have tryed using recode macro but it
was
not working. so is any one can please help me.it will be
grate help to me.


Any help