The delete worked fine for me under Excel 97. This line did error though:

MsgBox startrow.Row

That's because startrow is an integer not a range. It's a good idea to
declare your variables and use Option Explicit so you know what each is.

--
Jim Rech
Excel MVP