pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Meldoc prepapred this code:
Please expplain how this code works each line. Thanks alot!!!
Sub Pedie()
With Sheet1
lr = .Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To lr
If .Cells(i, "D").Value >= .Cells(2, "H").Value Then
.Range("A" & i & ":G" & lr).Copy Sheets("Home").Range("A1")
Exit For
End If
Next i
End With
End Sub
Please expplain how this code works each line. Thanks alot!!!
Sub Pedie()
With Sheet1
lr = .Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To lr
If .Cells(i, "D").Value >= .Cells(2, "H").Value Then
.Range("A" & i & ":G" & lr).Copy Sheets("Home").Range("A1")
Exit For
End If
Next i
End With
End Sub