Results 1 to 5 of 5

Macro copy doesnt work right

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2016
    Location
    Munich
    MS-Off Ver
    2010
    Posts
    3

    Macro copy doesnt work right

    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
    Last edited by JBeaucaire; 08-22-2016 at 09:57 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. the code doesnt work with macro event
    By samisamih in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-21-2015, 03:41 AM
  2. [SOLVED] Copy Past cells doesnt work in EXCEL file.
    By blake20 in forum Excel General
    Replies: 2
    Last Post: 08-26-2014, 02:26 AM
  3. Macro doesnt work when the sheet is protected
    By tsioumiou in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2011, 10:25 AM
  4. My loop macro doesnt work
    By matdog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2010, 02:32 AM
  5. My first macro - doesnt work - function not recognised
    By James Cornthwaite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2006, 12:20 PM
  6. some functions doesnt work in macro?
    By ExcelPower in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2006, 03:40 AM
  7. [SOLVED] Please help : Macro doesnt work on other PCs
    By Jason in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2005, 05:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1