Worksheet_event code may be good for this. If you use calculate it may fire
too often. You might like a worksheet_change event that says

if target.row=100 then rows(1).delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hol" wrote in message
...
Is there a code to delete rows automatically once it reaches row 100. But
to
delete from row 1.
--
hol