D
Dazed and Confused
I created a macro with hundreds of sets of criteria using Auto Filter to
delete rows that meet specific criteria. Here is an example:
Column A = 254
Column C = CTF
Shift + End + down arrow (to delete rows meeting this criteria)
Column A = 254
Column B = 220 or 221
Column C = WDI
Shift + End + down arrow (to delete rows meeting this criteria)
The problem is that this month's report does not have any values to meet the
second set of criteria, and therefore the remainder of my macro does not work
properly.
How do I write my macro to move on to the next set of criteria if it does
not find any values to meet the second set of criteria?
Thank you for any assistance!
delete rows that meet specific criteria. Here is an example:
Column A = 254
Column C = CTF
Shift + End + down arrow (to delete rows meeting this criteria)
Column A = 254
Column B = 220 or 221
Column C = WDI
Shift + End + down arrow (to delete rows meeting this criteria)
The problem is that this month's report does not have any values to meet the
second set of criteria, and therefore the remainder of my macro does not work
properly.
How do I write my macro to move on to the next set of criteria if it does
not find any values to meet the second set of criteria?
Thank you for any assistance!