FlatBanana
New Member
- Joined
- Mar 1, 2016
- Messages
- 7
I need some assistance with my code. I need to copy only from columns A-L not the entire row. How would I change "entirerow" to encompass on columns A-L?
Thanks
Thanks
Code:
Dim i, LastRow
LastRow = Sheets("Dump").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Open").Range("A2:I500").ClearContents
For i = 2 To LastRow
If Sheets("Dump").Cells(i, "F").Value = "" Then
Sheets("Dump").Cells(i, "F").EntireRow.Copy Destination:=Sheets("Open").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i