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
|