If...Then Coding Question

[FTM]

Why doesn't this work:

For i = 17 To FinalRow

'Check for 1750-1...

If ActiveCell.Cells("i, 4") = "1750-1" Then


End If

i = i + 13

Next i

My code is faulting out at the "If ActiveCell.Cells("i, 4") = "1750-1" Then" line. I want the content of the cell at i, 4 to equal 1750-1. The line passes the debugger and faults out on execution.

Thanks for the help.

Regards,

FTM The NOOB!

 

[jim may]

Try removing the " " inside the Cell()

If ActiveCell.Cells("i, 4") = "1750-1" Then

Like So...

If ActiveCell.Cells(i, 4) = "1750-1" Then

 

[FTM]

Sorry Jim,

No soap.

Care to take another swing?

Thanks,

FTM

 

[JoeMo]

Maybe this:
For i = 17 to FinalRow Step 13
If Cells(i,4) = "1750-1" Then
'do something here
End If
Next i

 

[FTM]

Thanks for the "Step" tip, I was wondering about how to incremet i.

The data in the source cell, "1750-1," originates in a pull down list. Is this an issue?

I'm sorry to waste everyone's time. It just occurred to me.

Thanks,

FTM

 

[JoeMo]

Thanks for the "Step" tip, I was wondering about how to incremet i.

The data in the source cell, "1750-1," originates in a pull down list. Is this an issue?

I'm sorry to waste everyone's time. It just occurred to me.

Thanks,

FTM

What kind of pull-down list - a validation list, a forms control or an active-x control?

 

[FTM]

It's a Validation List, I set the list up using the "Data" "Data Validation" tabs on the menu bar.

 

[JoeMo]

It's a Validation List, I set the list up using the "Data" "Data Validation" tabs on the menu bar.

Should not be a problem.

 

[FTM]

The line of code that works is, "If Range("D17") = Press Then." Does anyone know how to make the "D" a variable, e.g. an "i."

 

[Michael M]

You've kinda changed tack here....how does the last post relate to the one that JoMo provided an answer to ?