If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with macro
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! |
#3
|
|||
|
|||
Problem with macro
Hi,
Since you want us to fix your code, you need to show us the code. Very simply I am seconding Don's comment. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Dazed and Confused" 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! |
Thread Tools | |
Display Modes | |
|
|