+ Reply to Thread
Results 1 to 4 of 4

Have to modify codes to bypass the clipboard

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Have to modify codes to bypass the clipboard

    Some of my macro codes are recorded macros where I copy and paste. I have run into an issue where I will hit enter in a cell after running them and it will paste previously pasted info into that cell. To eliminate this I am bypassing the clipboard. I have been successful with codes that copy and paste a single cell but am unable to figure out how to do this with codes that copy and paste multiple cells.

    Please Login or Register  to view this content.
    The sheet I am copying this code from is the "Calculator" sheet. I have other macros that need modified but am pretty sure if I see how one is supposed to be formatted I can alter the rest, except this next one.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Have to modify codes to bypass the clipboard

    instead of whole first this shall do:
    Please Login or Register  to view this content.
    PS. Do you really want to go left from K2? (could be depending on spreadsheet design, but is less typical than right, so I'm asking).


    With Word - unfortunately I don't feel competent enough.
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Have to modify codes to bypass the clipboard

    Thank you. I had to add
    Please Login or Register  to view this content.
    and it worksFrom left or right works, but I changed it to go to the right so the code is more universal across multiple sheets. Some sheets only get about 2-3 columns filled before being cleared, some get hundreds of columns filled. I wasn't aware the resize portion of the code was what was preventing me from doing inserting multiple cells.

  4. #4
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Have to modify codes to bypass the clipboard

    Please Login or Register  to view this content.
    I inserted this at the end of my export to journal code and it worked.

+ 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] Write macro to bypass clipboard
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2014, 08:53 AM
  2. Bypass Clipboard when copy/pasting non-contiguous rows
    By mlj61289 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 03:11 PM
  3. [SOLVED] Is it possible to bypass the pw to modify all wb
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-15-2013, 04:02 PM
  4. [SOLVED] clipboard bypass not working
    By rossg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2013, 06:01 PM
  5. bypass clipboard too large comment
    By tdyl1969 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2009, 09:49 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