Problem with macro

  • Thread starter Thread starter Dazed and Confused
  • Start date Start date
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!
 
Hi,

Since you want us to fix your code, you need to show us the code. Very
simply I am seconding Don's comment.
 
Back
Top