How do I delete 250 rows on Excel sheet where ever a cell value =0
 

I have an Excel sheet with 2000 rows and I have the folowing formula on every
row with ab8, ab9,....ab2000
If(ab8=1,True,False) on the 8th row
If(ab9=1,True,False) on the 9th row, and so on
I want to write a macro that will delete every row if ab?=1 is false
Please help
Thanks

How do I delete 250 rows on Excel sheet where ever a cell value =0
 

Filter on column A for the False value, then delete those visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"K Suhail" <K wrote in message
...
I have an Excel sheet with 2000 rows and I have the folowing formula on
every
row with ab8, ab9,....ab2000
If(ab8=1,True,False) on the 8th row
If(ab9=1,True,False) on the 9th row, and so on
I want to write a macro that will delete every row if ab?=1 is false
Please help
Thanks