+ Reply to Thread
Results 1 to 3 of 3

pasting the content of multiple cells into multiple cells on another sheet

  1. #1
    Registered User
    Join Date
    07-11-2011
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    pasting the content of multiple cells into multiple cells on another sheet

    Below is some code I've been working on.
    I've underlined the line on which I'm stuck.

    Please Login or Register  to view this content.
    Right now, I've got this macro copying a cell, based on a condition, from one cell, into wk4.
    However. I don't just want that cell, but all of the info in that cell's row.
    Right now, I can paste into the desired cells, but I can't seem to copy the content of the desired multiple cells into those new cells. (I have "C_ell" on that side of the equation right now just as a placeholder).
    Argh, this is rather difficult to describe in words.
    I want to paste into the cells the content of C_ell.resize(0, F).
    The problem is that every time I try to tell the equation to = multiple cells, it sends an error message, or runs the macro without pasting anything in the desired cells.

    Can someone please help?
    Last edited by cubinity; 07-21-2011 at 09:33 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: pasting the content of multiple cells into multiple cells on another sheet

    Difficult to test this without any data or a sample workbook containing typical data.

    However, you have this line of code:

    Please Login or Register  to view this content.

    where last_cell is not defined ... and I can't see where it's used.

    Maybe that's something you need to look at.


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-11-2011
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: pasting the content of multiple cells into multiple cells on another sheet

    I solved the problem myself.
    What I was looking to learn was simply the equivalent to:
    Please Login or Register  to view this content.
    Thanks anyway. I learned a bunch figuring this out on my own.

+ 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