Sub lqxs()
Dim Arr
Sheet1.Activate
Arr = [A1].CurrentRegion
If UBound(Arr) > 3 Then
[I3:K3].AutoFill [I3].Resize(UBound(Arr) - 2, 3)
[I3].Resize(UBound(Arr) - 2, 3).Offset(1, 0) = _
[I3].Resize(UBound(Arr) - 2, 3).Offset(1, 0).Value
End If
End Sub
{:041:}