Case When Error with certain values

HI!!!

I'm having an unusual problem... I'm trying to look through a number of different columns for a certain value. If that value is there, then I want to copy over a certain range of cells into a new workbook. Some columns might contain certain values while other columns don't, and vice versa.

I have discovered the root of my problem. If the value (for example, 32) is NOT in the first column being searched, the rest of my case statement don't work, and I get the error "Run-time error '1004': Application-defined or object-defined error". See a sample of my code below (I have 20 cases in total, and several lines of code before/after this; it's just a sample)

Please Login or Register  to view this content.

If I set the criteria to a number that IS in the 1st column (example, 24) then it works.

I'm really stuck, any thoughts would be helpful!

Thanks.

Hi Leith Ross,

Previous code that I should've included:

Please Login or Register  to view this content.

I understand what you're saying, but my problem is not with the case statement itseld. It's the fact that it's searching for values that aren't in some columns (I think).

Thanks!

Hi Leith Ross!

Yes, at the beginning of each Case statement, I start off with ".AutoFilterMode = False" to turn it off. Any way I can say like "if cells null, don't copy"?

Sorry, I have no clue what to do!

Thanks