I am attempting to use the following code to paste the values only from one sheet to another. However, I am getting a run time error '1004'
I created this just from some examples and not really sure where I am going wrong? Any assistance with this would be much appreciated.
Thank you
[VBA]Sub alarmcopy()
Dim LR As Long, i As Long
LR = Range("B" & Rows.Count).End(xlUp).Row
For i = 27 To LR
If Range("J" & i).Value = "FLAG" Then Range("A" & i & ":I" & i).Copy
Worksheets("Old").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues
Next i
End Sub[/VBA]