| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows from one sheet containing deatils on the second sheet | New Users to Excel | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How do i delete duplicate rows in an Excel Spread Sheet | Excel Worksheet Functions | |||
| How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
| Delete rows from sheet | Excel Programming | |||
Linear Mode
