AW: Werte mit Makro einfügen
28.05.2016 19:45:40
Nepumuk
Hallo,
teste mal:
Option Explicit
Private Sub Übernehmen_Click()
Dim objCell As Range
With Worksheets("Datenverarbeitung")
Set objCell = .Columns(1).Find(What:="*", LookIn:=xlValues, Lookat:=xlWhole, _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
Call .Range(.Cells(2, 43), .Cells(objCell.Row, 55)).Copy
End With
With Worksheets("Datenerfassung")
Set objCell = .Columns(1).Find(What:="*", LookIn:=xlValues, Lookat:=xlWhole, _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
Call objCell.Offset(1, 0).PasteSpecial(Paste:=xlPasteValues)
End With
Set objCell = Nothing
Application.CutCopyMode = False
End Sub
Gruß
Nepumuk