This is a bit confusing (for me at least)...What I am wanting to do is, I have a graph on a worksheet that shows percentages. This graphs percentages are in rows F28 - F36. Sometimes the % will be 0%. Sometimes of course it will not be. I want to set it up to scan the range F28 - F36 and if if more than 2 in the range of F28 to F36 are greater than 0, but less than 6
...Run "Less6"
Then say if 6 or more are greater than 0
...Run "More6"

But I don't know how to have VBA scan a Range of values