Delete only cell and not row?
 

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

Delete only cell and not row?
 

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