+ Reply to Thread
Results 1 to 7 of 7

Macro to copy non adjacent cells to external workbook and move down row

  1. #1
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    2003, and 2007
    Posts
    150

    Macro to copy non adjacent cells to external workbook and move down row

    I have been looking around trying to find a code to copy data from nonajadcent cells into another workbook. I finally found this code and modified it to fit my needs.

    I keep getting a run-time error '9' Subscipt out of range.

    Could someone tell me what my problem is without me uploading the workbooks?

    Once I get the first line to work as needed, I have about twenty cells to copy/paste which I can do.

    Thanks in advance

    Please Login or Register  to view this content.
    Last edited by 2funny4words; 04-06-2010 at 04:59 PM. Reason: additional info

  2. #2
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Macro to copy non adjacent cells to external workbook and move down row

    The variable Call_Number doesn't appear to be set to anything.

  3. #3
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    2003, and 2007
    Posts
    150

    Re: Macro to copy non adjacent cells to external workbook and move down row

    Quote Originally Posted by yawnzzzz View Post
    The variable Call_Number doesn't appear to be set to anything.
    That is the name for the merged cells that the data is in

  4. #4
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Macro to copy non adjacent cells to external workbook and move down row

    Quote Originally Posted by 2funny4words View Post
    That is the name for the merged cells that the data is in
    That's your problem. It thinks it's a variable. Put quotes around it.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    2003, and 2007
    Posts
    150

    Re: Macro to copy non adjacent cells to external workbook and move down row

    Thanks, you are right, I think I should have known that but didn't see it.

    What do I need to add to the code to paste data only without any extras - colors, notes, etc.


    THANKS AGAIN

  6. #6
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Macro to copy non adjacent cells to external workbook and move down row

    You might have to go with this. I'm not sure the correct syntax for using 'Destination'.

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    2003, and 2007
    Posts
    150

    Re: Macro to copy non adjacent cells to external workbook and move down row

    thanks yawnzzzz,

    That was where I was headed but had not done it right.


    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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