I tried using delete but for some reason it doesn't work. The code I'
using is:

Private Sub CommandButton1_Click()
ThisWorksheet.Range [ItemN].Delete
ThisWorksheet.Range [Quantity].Delete

End Sub

I will attach the file to show what I mean.
Problems located on "Order Entry Sheet"

B.T.W
I am also having problems with my Process order button. After I hav
added Items to the order I press Process and get an error.
This does not occure if I don't specify a range to paste the copie
range into, but this means that the data could go anywhere on the shee
(last active cell) and not the location I wan

Attachment filename: book catalogue.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56071
--
Message posted from http://www.ExcelForum.com