Is there a code to delete rows automatically once it reaches row 100. But to delete from row 1.
H hol Nov 27, 2007 #1 Is there a code to delete rows automatically once it reaches row 100. But to delete from row 1.
D Don Guillett Nov 27, 2007 #2 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
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
H hol Nov 27, 2007 #3 Thank you Don, As I delete a rows will there be less rows overall or will there always be 65,000 rows regardless whether one is deleted or not?
Thank you Don, As I delete a rows will there be less rows overall or will there always be 65,000 rows regardless whether one is deleted or not?
