Hey coders got a (hopefully) easy one VBA

[Assassin]

Nope Field:1 works fine (it basically says Row A in Excel) and I can filter it to be "Name of person" or I can have a number "<=80" and it works but if I add in a second one so it says Field:1 blah blah, AND Field:=18, "number here" it breaks.

---------- Post added at 10:45 AM ---------- Previous post was at 10:31 AM ----------

I think because the code is pasting it into a new sheet..and I have the code saying active sheet it is checking the "newly created" sheets range of cells and coming back with null's. I may have to find the command to go back to the previous sheet.

[Assassin]

Ok close this please Maynard, Cyber or whover else. I got it.

[acolyte_to_jippity]

Ok close this please Maynard, Cyber or whover else. I got it.

no. NO!

you post what the fuck you did to fix this.

as an IT proffessional, there is NOTHIGN more annoying and/or asshole-ish than someone having a problem, posting on a forum for help, and then later saying "never mind i fixed it" WITH NO EXPLAINATION.

[Patmonster]

omg thank you!
As a fellow coder, I would like to see this as well. While I do not use excess very often I do wonder what was causing that.

[Assassin]

Apparently the code couldn't handle over like 912 cells at a time or some shit unless you made the constructor different. So I switched to the different one, took away all the selects except for those for the sheet name and the cells to copy and walla.