Private Function nlngCopywithData(ByRef pwksTarget As Worksheet, ByVal plngLineNo As Long) As Long
Dim wksActive As Worksheet
Set wksActive = ActiveSheet
pwksTarget.Parent.Activate
pwksTarget.Select
pwksTarget.Rows(CStr(plngLineNo) & ":" & CStr(plngLineNo)).Select
Selection.Copy
pwksTarget.Rows(CStr(plngLineNo + 1) & ":" & CStr(plngLineNo + 1)).Select
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False
nlngCopywithData = plngLineNo + 1
wksActive.Parent.Activate
wksActive.Select
End Function