+ Reply to Thread
Results 1 to 7 of 7

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

  1. 04-06-2010, 01:31 PM #1
    2funny4words
    2funny4words is offline
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    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
    Reply With QuoteRegister To Reply
  2. 04-06-2010, 01:47 PM #2
    yawnzzzz
    yawnzzzz is offline
    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.
    Reply With QuoteRegister To Reply
  3. 04-06-2010, 02:04 PM #3
    2funny4words
    2funny4words is offline
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    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
    Reply With QuoteRegister To Reply
  4. 04-06-2010, 02:25 PM #4
    yawnzzzz
    yawnzzzz is offline
    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.
    Reply With QuoteRegister To Reply
  5. 04-06-2010, 02:38 PM #5
    2funny4words
    2funny4words is offline
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    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
    Reply With QuoteRegister To Reply
  6. 04-06-2010, 03:07 PM #6
    yawnzzzz
    yawnzzzz is offline
    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.
    Reply With QuoteRegister To Reply
  7. 04-06-2010, 04:55 PM #7
    2funny4words
    2funny4words is offline
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1