Quick Simple Newbie Question

[Alfred12]

Hi all --

Can someone please tell me what is wrong with this line of code:

If Cells(i, 4).Value = 1 Then

This line appears in a for next loop being counted by the variable "i". The idea is to look at the value in column D in all the rows, and if the cell contains the number 1, the "then" part is executed.

It compiles fine, and I've got messages inserted so that I know that this line is being executed. But it is not finding my "1"s to trigger the "then" action. (And in my test cases I certainly have some "1"s in the D column.) What super-basic obvious thing am i missing?

It is as if there is no tutorial basic enough for me!

Thanks!

Alfred

 

[Alfred12]

All the loops appear to be working fine -- that is, it is counting through variable S and i, and it is walking through each sheet as it should. But I can never get the second test message to show up. In other words the "if" statement" is apparently never getting triggered.

Very frustrating. I feel like I must be overlooking something silly and obvious.

Alfred.

 

[Alfred12]

Could it be because the values in column D are the result of a formula? Do I need to do something different in that case, as opposed to if I just entered the numbers manually into that column?

If Cells(i, 4).Value = 1 Then

 

[Alfred12]

Ok -- please disregard this thread. I've made a lot of progress on my own. I've moved on to a new set of issues, and perhaps I'll ask about those if I cannot crack them myself.

Thanks again!