Results 1 to 4 of 4

How To Copy & Paste Data From One Tab To A Certain Cell In Another

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2021
    Posts
    1,013

    How To Copy & Paste Data From One Tab To A Certain Cell In Another

    Hi,

    I'm trying to copy and paste data from one tab to the first empty row below existing data on another tab. My problem occurs at the red text below. I don't want to paste the copied data into cell 'A3110' that just happened to be the next free cell below the existing data when I recorded the macro. How can I amend it to achieve what i'm after?

        Range("A2").Select
        Range(Selection, Selection.End(xlToRight)).Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.Copy
    
        Sheets("Data").Select
        Range("A1").Select
        Selection.End(xlDown).Select
        Range("A3110").Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
    Thanks in advance,

    Snook
    Last edited by The_Snook; 12-31-2011 at 08:09 PM.

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