+ Reply to Thread
Results 1 to 2 of 2

Macro doesnt Paste, can't find the error

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Groenlo, Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    63

    Macro doesnt Paste, can't find the error

    I made the following Macro, which used to work. Somehow it doesn't work completely.
    It should open excel files and copy a specific Sheet to the Excel file containing the Macro on a Sheet with the same name. The Sheets are created, the files are being opened, the correct Tab and Range are selected, but somehow the data is not pasted. What am I missing?


    HTML Code: 

  2. #2
    Registered User
    Join Date
    05-31-2012
    Location
    Groenlo, Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    63

    Re: Macro doesnt Paste, can't find the error

    Found it, should be Active Sheet.Paste, instead of Selection.Paste

+ 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. [SOLVED] first timer using VB to cut and paste macro - getting compile error syntax error
    By jopedder in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2013, 11:45 AM
  2. Powerpoint macro to paste and format doesnt work anymore
    By mikeTRON in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 07:44 PM
  3. [SOLVED] Macro doesnt paste value the result of the formula but the formula itself..
    By extremis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2013, 11:06 AM
  4. Excel Macro Error - Run time error 1004 - Paste method of worksheet class failed
    By kvflynn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2012, 10:51 AM
  5. macro error > object doesnt support property
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 07-24-2011, 05:06 PM
  6. find function doesnt find imported info
    By dscott2479 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-12-2011, 07:11 PM
  7. Paste Special Doesnt work
    By OliverLees in forum Excel General
    Replies: 1
    Last Post: 10-25-2007, 10:05 PM
  8. [SOLVED] Paste special doesnt have values
    By Ron in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2006, 08:00 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