| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Delete in Excel using Macro
OK, here is the criteria -
Column A can be 2 values - Error or Valid Coumn B can be multiple values for a country...say US, CA, UK... Column C can be multiple values for a type...Hardware, Software, Warranty... I have set up an auto-filter using the AUTO_OPEN macro for ErrorIND, COUNTRY, TYPE etc... So my criteria for deletion is (using values from auto-filter) ErrorIND = Error Country = CA Type = Software All such rows should be deleted by the macro and nothing else.. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete conditional formatting via macro | Excel Discussion (Misc queries) | |||
| Macro code to delete conditional formatting | Excel Discussion (Misc queries) | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Threaded Mode
