Thread: Loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default 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