How to use Select Case in a loop

[mikea3]

Hi - I've been using the following code which I found here in the forum earlier to delete rows when a value is not present in a cell, but now I need to check for up to 25 possible values in the same cell. In other words if cell i,10 is not equal to one of the Twenty Five values then delete the row. I know it's probaby a select case but I'm pretty much a novice with VBA and can't get any of my Case variations to work.

Please Login or Register  to view this content.

Thanks for your help /Mike

[shg]

Mike,

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

[shg]

Please Login or Register  to view this content.