I
then push the button to launch the data entry form and get the
following VBA
message. Run-time error '1004': Delete method of Range class failed. Te
code
behind the form does indeed delete a cell at the start. The form does
not
appear. If I select debug on the error message I am taken to the code
performing the delete operation.

When you message comes up, have you pressed help to see what was up?
Does the message come up only when there is nothing to delete?

Just wondering, need more info,
I have had macros that searched for a word and delete the row, if it
couldn't find the word I would get an error, so ended needing some
extra code like
on error exit sub


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522047