Code to count under certain condition

[Marceltcm]

Hi everyone,
Could someone identify whatīs wrong with my code below?
I want it to count under a certain condition and then store the total number in a variable, but Iīm getting a "0" answer. The code is like follows:

Please Login or Register  to view this content.

Tnx!

[Jakobshavn]

You must test each cell separately.

[HaHoBe]

Hi, Marceltcm,

please wrap up your procedure in code-tags.

I wouldnīt use a loop:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Annd maybe you could alter the title for this thread - itīs not really what Forum Rule #1 calls for.

Ciao,
Holger

[Marceltcm]

You must test each cell separately.

I tried it but didnīt work yet

[Mumps1]

Try:

Please Login or Register  to view this content.

[Pepe Le Mokko]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Marceltcm]

Hi, Marceltcm,

please wrap up your procedure in code-tags.

I wouldnīt use a loop:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Annd maybe you could alter the title for this thread - itīs not really what Forum Rule #1 calls for.

Ciao,
Holger

I couldnīt do in that way because I have to test the three numbers of each line, if they satisfy the condition then I sum 1 to the variable

[Marceltcm]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.


To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Sorry, Iīve changed it already.
Tnx

[HaHoBe]

Hi, Marceltcm,

as you have changed the title maybe you also add the code-tags in the opening post.

Sorry for my fault (I used a less instead of a greater sign). Shouldnīt it be And instead of Or for summing up each single line?

Please Login or Register  to view this content.

And please do not quote full posts but only the necessary parts of these posts if neede (or make clear to which person you are answering).

Ciao,
Holher

[Marceltcm]

Tnx HaHoBe! I think it worked now. But i wish to understand why the dots before "cells".
Tnkx!

[HaHoBe]

Hi, Marceltcm,

in your code you activated Sheets("Geral"), so it was the ActiveSheet. Any Ranges and Cells are taken from the active sheet.

I used a With-Statement which doesnīt make it necessary that Sheet("Geral") is the active sheet. But having stated above that any range or cell refers to the active sheet I must make clear to VBA to take the ranges and cells from the sheet which is referred to in the With-Statement (thus using the dot in front of Cells(...)).

You still havenīt added code-tags in the opening post.

Ciao,
Holger

[Marceltcm]

Got it, tnx so much!