+ Reply to Thread
Results 1 to 5 of 5

Macro copy doesnt work right

  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:
    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro copy doesnt work right

    Maybe:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

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

    Re: Macro copy doesnt work right

    thanks for the reply.
    Saldy no, still the second copy doesnt happen. I have my clipboard open and so i see what lands there.
    Weird thing is if i run the macro twice i get the second copy.

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

    Re: Macro copy doesnt work right

    anyone else got an idea why the copy after the paste doesnt go to clipboard?

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Macro copy doesnt work right

    You don't need to 'copy'.

    Please Login or Register  to view this content.
    oder

    Please Login or Register  to view this content.
    Last edited by snb; 08-24-2016 at 06:32 AM.



+ Reply to Thread

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. 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