Referencing variable
 

I want to run the followingcode in specific columns, but
in several different rows. The columns will always stay
the same, but the number of rows will be different each
time I run the code.

If Range("h2") = "Procedural" Then
Range("j2").Formula = "Procedural"
Exit Sub
ElseIf Range("f2") 0 Then
Range("j2").Formula = "Overpayment"
ElseIf Range("g2") 0 Then
Range("j2").Formula = "Underpayment"
End If

I'm using a count procedure to count number of rows in the
usedrange, and figured I'd use a loop statement, but I
can't see how to reference the rows as variables.

Thanks,
Lee

Referencing variable
 

for i = 2 to 100
If Cells(i,8) = "Procedural" then
Cells(i,10).Formula = "Procedural"
exit Sub
Elseif

and so forth.

Replace 100 with a variable that contains your count.

--
Regards,
Tom Ogilvy


"Lee" wrote in message
...
I want to run the followingcode in specific columns, but
in several different rows. The columns will always stay
the same, but the number of rows will be different each
time I run the code.

If Range("h2") = "Procedural" Then
Range("j2").Formula = "Procedural"
Exit Sub
ElseIf Range("f2") 0 Then
Range("j2").Formula = "Overpayment"
ElseIf Range("g2") 0 Then
Range("j2").Formula = "Underpayment"
End If

I'm using a count procedure to count number of rows in the
usedrange, and figured I'd use a loop statement, but I
can't see how to reference the rows as variables.

Thanks,
Lee