+ Reply to Thread
Results 1 to 16 of 16

copy & paste macro not working

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,866

    Re: copy & paste macro not working

    Quote Originally Posted by markswan111 View Post
    step1- I need the vba to copy every other sell in range A163:A430 in book2, and paste the values starting with any selected cell in column B in book1

    step2- I need the vba to copy range c163:g430 from book2, and paste the values in column P of book1 starting with the same selected row number in step1

    step3- I need the vba to copy every other sell I163:I430 in book2, and paste the values in column W of book1 starting with the same selected row number in step1
    Your original post did not say that you want to copy every other cell, and that is not what your code does. Please clarify what you want to do here.

    Your original post did not mention anything about what you describe here as "step3".

    You have not told me what error code and message you get on that line of code you described in post #4.

    Of the two files you attached, which one is 1.xlsb and which one is ODELIS220233.xlsb?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Registered User
    Join Date
    04-28-2016
    Location
    usa
    MS-Off Ver
    2007
    Posts
    48

    Re: copy & paste macro not working

    Dear Sir,

    in my first post I posted a vba and was planning to add other steps to it after I get an answer, then I thought it is safer and better to re do everything and ask for help with what I want done all together and I made clean files and posted them for you in my last post.

    so what I want is exactly what is posted in my last post, even the workbooks names are all correct and updated

    so in summary we can discard everything I posted and just refer to the very last post with the 2 files in it

    again thank you so much and sorry for the confusion

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,866

    Re: copy & paste macro not working

    Quote Originally Posted by markswan111 View Post
    we can discard everything I posted and just refer to the very last post
    Which is why we ask for a concise explanation of what you need.

    The code needs an extensive rewrite to copy and paste every other cell. I will see when I can do this.

  4. #4
    Registered User
    Join Date
    04-28-2016
    Location
    usa
    MS-Off Ver
    2007
    Posts
    48

    Re: copy & paste macro not working

    Dear 6string,
    thank you much for your help, I do not want to trouble you in rewriting, I will try to do it myself and I will post the code here and ask you with concise explanation if I need anything....
    again you are much appreciated as you are the only one here who really tried to help and be patient with an open heart ,again thank you, and you are much appreciated....

+ 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] VBA Macro to copy/paste and mail some data, but it's not working!
    By nitozinho in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2016, 10:51 AM
  2. Copy and paste special macro not working
    By AndyF19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2016, 11:37 AM
  3. Excel Copy and Paste Macro not working
    By LewisLonsdale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2015, 01:14 PM
  4. Copy paste - cute paste macro almost working
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2014, 12:33 PM
  5. [SOLVED] Find, then copy and paste macro not working
    By ufopilot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2014, 06:46 AM
  6. [SOLVED] Macro to copy, then paste row in multiple sheets not working
    By dystopianprotagonist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2013, 09:37 PM
  7. copy paste macro not working
    By nicko54 in forum Excel General
    Replies: 1
    Last Post: 01-05-2011, 05:25 PM

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