Hi everyone,
i need to fill specific range with soemething i have copied to clipboard and then copy the same plus extra rows to clipboard, so can paste these to a different text file.
Heres my macro:
Sub GOGO()
Worksheets("SPF-Schreiben").Unprotect
ActiveSheet.EnableOutlining = True
ActiveSheet.Outline.ShowLevels RowLevels:=2
Worksheets("SPF-Schreiben").Range("l12:l" & Cells(Rows.Count, "D").End(xlUp).Row).Select
Selection.Copy
Range("AN35").Select
Selection.PasteSpecial Paste:=xlValues
Application.CutCopyMode = False
Range("AN12").Select
Range(Selection, Selection.End(xlDown)).Copy
ActiveSheet.Range("D13").Select
End Sub
Problem is that just the first copy goes to clipboard, the second isnt registered. Anyone got a suggestion??
Been at this for ages and cant figure out whats wrong. Also i cant delete the clipboard via the macro.
Thanks in advance
Vin
Bookmarks