+ Reply to Thread
Results 1 to 4 of 4

Paste Range into specific cells

  1. #1
    Registered User
    Join Date
    01-24-2017
    Location
    home
    MS-Off Ver
    MS Office 2016
    Posts
    46

    Paste Range into specific cells

    I am currently using the below code to copy data from a file of the users choice and paste it onto the new file. When I set the paste range as just C3, everything works fine but the copied cell from C3 goes into cell C4, etc., which I do not want. Is there a way that I can copy the cells that I want and choose their destination cell?

    Currently if I break the code down for each individual cell to copy and paste, it works but the screen flickers a lot.


    Please Login or Register  to view this content.

  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,446

    Re: Paste Range into specific cells

    Try it like this:

    Please Login or Register  to view this content.
    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
    01-24-2017
    Location
    home
    MS-Off Ver
    MS Office 2016
    Posts
    46

    Re: Paste Range into specific cells

    Did exactly what I wanted. Thank you!

  4. #4
    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,446

    Re: Paste Range into specific cells

    You're welcome. Thanks for the rep.

+ 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. Row titles & values copy & paste with non blank cells in specific range
    By nandhavnk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2022, 11:44 AM
  2. Copy 2 specific Sheets, specified range, paste as values to a specific folder
    By wherdzik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2021, 08:35 AM
  3. [SOLVED] Paste value (Transpose) to specific Range in Cells via InputBox
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2020, 04:46 AM
  4. VBA Macro: Copy and Paste Specific Row Range based on the Specific Value in a Cell.
    By SolidSmoke in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-10-2016, 02:40 PM
  5. Replies: 3
    Last Post: 11-18-2015, 03:31 PM
  6. copy a range of cells N times and paste in separate sheet and also change a specific colum
    By maramkarthik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2013, 04:27 AM
  7. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 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