Bulk row deletion
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.
|