Nader
02-29-2008, 10:54 AM
Have you faced like this problem before
I used both of these code to do same thing and I found smae problem
the problem is when I copy the items form sheet1 to material sheet and then delete the item in material sheet manually ( selected by mouse and use delete key) and try to release the code again. It copy the item in a new rwos, but if I use the code :
Cells.Clear to delete the items, they copy them in previous rows. They work very well.
Here is the file
I used both of these code to do same thing and I found smae problem
the problem is when I copy the items form sheet1 to material sheet and then delete the item in material sheet manually ( selected by mouse and use delete key) and try to release the code again. It copy the item in a new rwos, but if I use the code :
Cells.Clear to delete the items, they copy them in previous rows. They work very well.
Here is the file