I'm having trouble getting a code to work. I've seen several post for "if they meet criteria," but not too many to address what I need. There are far too many that I do not want and a manageable amount that I want to keep for any given report. Here is what I have, hopefully someone can correct it or offer something better. Thanks in advance.
Please Login or Register to view this content.
Most of the time, for multiple <> statements, you will want ANDs instead of ORs.
You could also use AutoFilte which would be faster.
But Since you already have your loop, try the AND thing first
Hi blaque,
Here's one way to do it :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Oups,
I believe I got the code wrong. If you want to keep the rows matching you criteria, this should work better :
Please Login or Register to view this content.
Guys thanks for your help. My loop must have a flaw because even with the "AND" it would leave some of the unwanted ticket types. I believe this is due to it skipping one once a row is deleted. GC Excel your solution worked perfect. Thanks a lot your both of your help!
Hey Blaque,
Glad you got it to work.
As a side note, yes you are right.
The reason the ANDs didnt work is beacsue if you are deleting rows, you have to go from bottom up instead of top down using step -1 like GC did.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks