How are you triggering the code - if with a commandbutton,
try changing the takefocusonclick property to false
- just a guess of course.

Yes, Tom. And a good guess at that! Relatively inexperienced a
applying VB to Excel (97), I've been fighting this problem for too man
hours with MS "Help" offering no clue as to WHY the delete failed wit
every variation I put in the command. Taking the focus off the butto
did the trick, and in retrospect it became clear as to why the delet
failed. Thanks very much!

To

--
Message posted from http://www.ExcelForum.com