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 |
Loop
|
All times are GMT +1. The time now is 09:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com