Problem with macro

  • Thread starter Dazed and Confused
  • 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!
 
S

Shane Devenshire

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top