Simple Formula to delete every other row

S

Sandman

Is there a simple formula that will allow me to delete every other row? any
help would be appreciated
 
D

Don Guillett

You can't delete rows with a formula. You need a macro something like this

for i = cells(rows.count,"a").end(xlup).row,"a") to 2 step -2
rows(i).delete
next
 
S

Sandman

Thanks

--



You can't delete rows with a formula. You need a macro something like this

for i = cells(rows.count,"a").end(xlup).row,"a") to 2 step -2
rows(i).delete
next
Click to expand...
 
Top