AuotFilter

[Nick3535]

Hi
I need to add a code that says if The criteria = 0 or is Blank (Like in Sheet(King) C3:G3) then nothing will be copied to Sheet(King). As you can see it will still copy the headers even though there is nothing in the Criteria cell.

This entire Marco may be wrong. This is the first one I have tried to build and I have never had any exposure to it before I starting this a couple days ago.

Thanks for the Help!

[Nick3535]

Anybody out there?
Not to be pushy but I need help ASAP!!!!!!!

The macro I have now works. I just need a code that will do what I tried to explain earlier.

Thanks. I really appreciate any help.

[jaslake]

Hi Nick3535
See if this code helps

Please Login or Register  to view this content.

John

[Nick3535]

John
That’s perfect. Thanks for the help!!

One quick question. Do you know of any programs or books orsomething like that I could get to learn how to do this? It took me almost 3 days to make that simple code.

Nick

[jaslake]

Hi Nick

Glad it helps. Regarding your question...my personal experience (which is limited) is that Google is your best friend. Probably 2 years ago, I was having a problem similar to yours. I wrote a macro that performed an auto filter but it wasn't finding any records which screwed up later steps in the procedure. So, I Goggled on something like "Count visible cells VBA" figuring if I could count them, I could make the procedure deal with it if it came up with no records.

Bottom line, there's not a problem you'll run into that hasn't been seen before and it's more than likely been discussed on the Web. That's where I do my research. Books give examples but they're typically very simplistic. You'll get more specific answers on the Web.

Hope this helps. If you're satisfied with the solution, please mark your thread as solved. A tip of the scales (upper right hand corner of any post on your thread) will be greatly appreciated.

John