S Sandman Jul 29, 2004 #1 Is there a simple formula that will allow me to delete every other row? any help would be appreciated
Is there a simple formula that will allow me to delete every other row? any help would be appreciated
D Don Guillett Jul 29, 2004 #2 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
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 Jul 29, 2004 #3 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...
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...
