I'm trying to copy a range of a row to another sheet if column AL contains an O. It errors out on Selection.End(xlDown).Offset(1, 0).Select.
Will someone please help me with this?
Will someone please help me with this?
Code:
Sub CopyOdds()
Sheets("Cab. Order").Select
For i = 16 To 300 Step 1
If Range("AL" & i) = "O" Then
Range("c" & i & ":" & "K" & i).Select
Selection.Copy
Sheets("Odds").Select
Range("C2").Select
Selection.End(xlDown).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Next i
End Sub