+ Reply to Thread
Results 1 to 2 of 2

Trouble copying filtered data to new Workbook- Run-time Error 13

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2013
    Posts
    14

    Trouble copying filtered data to new Workbook- Run-time Error 13

    Hello,
    I need some help with this bit of code... I'm attempting to copy filtered data from one Workbook to a newly created Workbook and I'm having trouble with the paste function. I'm using the debug 'run to cursor' function and it seems to hang up when I activate the destination workbook-- I get a "Run-time Error 13, mismatch type". I'm not very good at coding, so I'm sure I've missed some very elemental steps in the process. Any help would be greatly appreciated! My code so far:

    Please Login or Register  to view this content.
    Last edited by izzorac; 06-25-2014 at 02:35 AM. Reason: Added code tags

  2. #2
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2013
    Posts
    14

    Re: Trouble copying filtered data to new Workbook- Run-time Error 13

    Bump..still need help!

    Thank you in advance for your consideration.

+ 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. Run-time error '1004' when pasting worksheet into existing workbook
    By ajmartin17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2013, 07:03 AM
  2. Filtering in another workbook, copying filtered data and pasting in source workbook
    By saadtariq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 12:55 PM
  3. Runtime error 1004 when copying and pasting a filtered collumn excel 2010
    By Shedacq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2012, 06:35 AM
  4. Trouble cut/pasting between sheets in same workbook
    By BeefNoodleSoup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2011, 10:26 PM
  5. [SOLVED] Pasting on Filtered Data Sheets without pasting onto hidden cells
    By CCSMCA in forum Excel General
    Replies: 1
    Last Post: 08-28-2005, 09:05 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