Trying to automate the copying of some rows, fails on the paste special section, and I cant figure out why!!
Dim LR As Long, i As Long
LR = .Range("A" & Rows.Count).End(xlUp).Row
For i = 12 To LR
If .Range("K" & i).Value = "CORB01" Then...