It would be a good idea to supply your macro as we cannot give help or
advice on the information you have given except to say use an IF ELSEIF
statement.

Dazed and Confused;259690 Wrote:
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!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72517