+ Reply to Thread
Results 1 to 2 of 2

Pasting values from the clipboard

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    uk
    MS-Off Ver
    Excel 2013
    Posts
    15

    Question Pasting values from the clipboard

    I have two workbooks A and B.

    I need to copy information from workbook A and paste these values into workbook B.

    Although I can do this (and record the macro at the same time) when I attempt to run the macro I get the 1004 Paste special method of worksheet class failed error. I'm sure I'm missing something simple but not sure why it will let me do it when recording the macro but not when running it?

    The code I am using is below, the debug indicates it's the ActiveSheet.Paste causing the issue. I've tried copying the entire sheet/columns/rows only but with the same result (plus an irritating merged cells issue)

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: Pasting values from the clipboard

    I dont know why you get that error but if i do remember correctly you can not record the switch to another workbook

    the macro you have recorded now is just selecting range D21 then pasting whatever is in your clipboard at that moment then copy that and pasting it again at the same range.
    If you describe exactly what you want to do we can maybe help you to build it

+ 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. Clearing column and pasting from clipboard
    By itamaro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2015, 03:56 PM
  2. [SOLVED] Pasting clipboard contents using VBA
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2015, 09:41 PM
  3. [SOLVED] Pasting range from clipboard
    By mattmania in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2013, 09:20 AM
  4. How do I insert a column without pasting from the clipboard?
    By Dave42 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2012, 06:06 AM
  5. Pasting date values from clipboard - help
    By tbilisi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2008, 07:41 AM
  6. [SOLVED] Excel clipboard should allow pasting of formulae not just values
    By Desperate Don in forum Excel General
    Replies: 0
    Last Post: 04-28-2005, 01:06 PM
  7. VBA Bloomberg, Clipboard Pasting Problem
    By Teiresias in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2005, 06:32 AM

Tags for this Thread

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