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)
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!