Home » Blogs » Nick's blog

XLA routines: EE_CopyAndAddToTheEnd

Nick's picture
Submitted by Nick on 8 February, 2015 - 08:00
EE_CopyAndAddToTheEnd takes the range to copy, the destination sheet, the header that the range will be copied in, and the row - useful for reconciling data 
Sub EE_CopyAndAddToTheEnd(RangeToCopy As range, DestinationSheet As Worksheet, DestinationSheetPasteRow As Long, DestinationSheetPasteColHeader As String)
    'Basically the same as EE_copy, but Takes a destination sheet
    'and appends data to the end
'http://excelexperts.com/xla-routines-eeCopyAndAddToTheEnd    for updates on this routine
    Call EE_Copy(RangeToCopy, DestinationSheet.Cells(DestinationSheetPasteRow, EE_TableHeadingCol(DestinationSheetPasteColHeader, ActiveSheet.UsedRange)), True, False)
End Sub
»