Hi,
I'm trying to run a program that goes down row by row, checks if two values are equal, and if not, replaces the second value with the first.
I currently have a for loop set up as follows:
For int i = 1 to 5
(code)
If Counter > Counter2 Then
Worksheets("Sheet1").Range("A1:I1").Copy
Worksheets("Sheet1").Range("L1:T1").Select
Selection.Insert Shift:=xlDown
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("L1:T1")
End If
Next i
It checks the values correctly, but right now it just outputs the range A1:I1 5 times. I want it to output a range Ai:Ii, where i is the integer I'm using for my for loop.
Is this possible?
Thanks in advance for your help.
Bookmarks