Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to use autofilter in code to show only certain rows with many
criteria? For example, I need to display and delete only those rows conforming to all of the following: Column A: Cells like "###.###.####.######.###.##.###" Columns C, D, E: Abs(C) + Abs(D) + Abs(E) = 0 Column F: < "U" Once displayed, these rows will then be deleted. Your example code would be most appreciated. FYI: my original sheet contains 54,102 rows by 22 columns. About 29,000 rows will be deleted. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bulk Discount Formula | Excel Discussion (Misc queries) | |||
Bulk vlookup? | Excel Worksheet Functions | |||
Removing hyperlinks in bulk | Excel Discussion (Misc queries) | |||
Removing hyperlinks in bulk | Excel Discussion (Misc queries) | |||
Bulk Email | Excel Programming |