Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear data and hide rows.
I am looking for macro that will remove data from rows with zero value and
hide that rows. For example, there is 3 columns, some rows contains data like this: 5962-9090801MVA abc CONVERTER I.C. 0.00 5962-9092701M3A 8Bit 35Msps Mil ADC 0.00 5962-9092701MXA 8Bit 35Msps Mil ADC 0.00 5962-9092702M3A 8Bit 35Msps Mil ADC 0.00 I just need search for rows like this, clear this data and hide this rows. And the same thing for whole worksheet. thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear entire rows below last row of data in col A except in 1st 3 sheets | Excel Programming | |||
Clear rows with no data? | Excel Programming | |||
Trying to hide all rows where no data is in columns AQ-AV | Excel Programming | |||
Help to clear data & delete rows | Excel Programming | |||
Macro to hide rows containing no data | Excel Programming |