AW: Excel VBA - Kopieren Inhalte in anderes Arbeitsbl.
20.11.2018 12:43:33
{Boris}
Hi Pascal,
nicht kopieren, sondern direkt zuweisen.
Ungetestet:
Private Sub CommandButton1_Click()
Dim wksL As Worksheet
Dim wksR As Worksheet
Dim lngNextRow As Long
lngNextRow = wksR.Cells(wksR.Rows.Count, 1).End(xlUp).Row + 1
Set wksL = ActiveWorkbook.Worksheets("Checkliste")
Set wksR = ActiveWorkbook.Worksheets("Archiv-Gesamtübersicht")
wksR.Cells(lngNextRow, 1).Value = wksL.Cells(1, 4)
wksR.Cells(lngNextRow, 2).Value = wksL.Cells(4, 2)
wksR.Cells(lngNextRow, 3).Value = wksL.Cells(3, 2)
wksR.Cells(lngNextRow, 4).Value = wksL.Cells(3, 4)
wksR.Cells(lngNextRow, 5).Value = wksL.Cells(2, 4)
wksR.Cells(lngNextRow, 6).Value = wksL.Cells(4, 4)
wksR.Cells(lngNextRow, 7).Value = wksL.Cells(7, 3)
wksR.Cells(lngNextRow, 8).Value = wksL.Cells(10, 3)
wksR.Cells(lngNextRow, 9).Value = wksL.Cells(12, 3)
wksR.Cells(lngNextRow, 10).Value = wksL.Cells(13, 3)
wksR.Cells(lngNextRow, 11).Value = wksL.Cells(17, 3)
wksR.Cells(lngNextRow, 12).Value = wksL.Cells(20, 3)
wksR.Cells(lngNextRow, 13).Value = wksL.Cells(25, 3)
wksR.Cells(lngNextRow, 14).Value = wksL.Cells(27, 3)
wksL.Cells(4, 2).ClearContents
wksL.Cells(3, 2).ClearContents
wksL.Cells(3, 4).ClearContents
wksL.Cells(2, 4).ClearContents
wksL.Cells(4, 4).ClearContents
wksL.Cells(7, 3).ClearContents
wksL.Cells(10, 3).ClearContents
wksL.Cells(12, 3).ClearContents
wksL.Cells(13, 3).ClearContents
wksL.Cells(17, 3).ClearContents
wksL.Cells(20, 3).ClearContents
wksL.Cells(25, 3).ClearContents
wksL.Cells(27, 3).ClearContents
If Range("D1") = 0 Then
Range("D1") = 500
Else
Range("D1") = Range("D1") + 1
End If
End Sub
VG, Boris