Loop
the number of rows can vary so i have put a rowcount
RowCount = Cells(Rows.Count, "L").End(xlUp).Row
here is what i am trying
for x = 1 to rowcount
ActiveCell.Offset(1, 0).Select
Range("ab1").Value = ActiveCell.Value
If Range("Ab1").Value = 1 Or Range("Ab1").Value = 2 Then
Here is where i not sure
End If
Next x
|