Excel Debugging Issue

[Vinkebot]

Hi Here is my code. It's my first day using excel's VBA tool, and I'm getting a mismatch error on the bolded line. Here is my data set.
Screen Shot 2016-06-27 at 1.06.55 PM.png

Please Login or Register  to view this content.

[AB33]

Please use code tags with your code as per forum's rule.
There is no cell zero

Please Login or Register  to view this content.

[Vinkebot]

I think I fixed the old problem. Could anyone help me with the new code.

The Goal: I'm basically trying to get an average value (from the 2s and 3s in the middle column) for each of the ones that appear in the one to the left. I want the values to show up in the empty column on the right.

[AB33]

Please attach a sample book, showing your desired result. I dread though, you are on Mac.

[Vinkebot]

Something like this
Screen Shot 2016-06-27 at 1.18.26 PM.png

[bakerman2]

Please Login or Register  to view this content.

Different from space?

[Vinkebot]

Hm what do you mean by that. I was basically trying to use this line to write the condition (as long as the cell is not empty).

[bakerman2]

Please Login or Register  to view this content.

Look for the difference.

[Vinkebot]

Oh ok. I still get the type mismatch error after that change.

[humdingaling]

2.66666667 is not an integer

Please Login or Register  to view this content.

try long instead?

[protonLeah]

deleted by bvj

[xlnitwit]

Your code is declaring Count and j, 3741 times each.

Hi,

That is not actually the case. As long as you don't try and use a variable in a line that precedes its declaration, it's really just a matter of preference where the declaration is. Even inside a loop the compiler will only declare it and allocate memory once.

[bakerman2]

Based on your image in post#5

Please Login or Register  to view this content.