Advanced Filter

**romperstomper** · 08-20-2010, 07:22 AM

Your code makes very little sense, which is why I asked for a file.
For example, what is this supposed to do:

x = 1 <= 9

?

**flebber** · 08-20-2010, 10:55 AM

Originally Posted by romperstomper

Your code makes very little sense, which is why I asked for a file.
For example, what is this supposed to do:

x = 1 <= 9

?

Yeah my code is a bit of a mess because I am still really new to this.

x = 1 <= 9

Just supposed to make x have a value of between 1 and 9 because their are up to 9 classes in my data.

I will work on my code a bit more and see how I go. Really what I am aiming to do is simple its me making it hard - filter, count, paste on another sheet and a quick sum ot two and go again.

Just goes to prove newbies can make anything hard