Results 1 to 4 of 4

Paste Value After Data

Threaded View

luke6843 Paste Value After Data 02-20-2009, 01:10 AM
shg Re: Paste Value After Data 02-20-2009, 01:38 AM
royUK Re: Paste Value After Data 02-20-2009, 03:32 AM
DonkeyOte Re: Paste Value After Data 02-20-2009, 03:47 AM
  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    las vegas, nevada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Paste Value After Data

    I am attempting to copy data from sheet A (macro_sort) and paste value in sheet B (book) at the end of the data in sheet B. I am constantly adding data to sheet B so I need it to paste the new data after the existing data. I have included a copy of the code I am using. Currently it is pasting the data but not by value and not after the existing data; it is wiping out much of the existing data.

    Sub book()
    Dim a, b As Long
    a = Sheets("macro_sort").Range("A" & Rows.Count).End(xlUp).Row
    b = Sheets("book").Range("A" & Rows.Count).End(xlUp).Row
    Sheets("macro_sort").Range("C4:H" & 5000).Copy Destination:=Sheets("book").Range("B" & b)
    End Sub
    My macro skills are very very basic so I would appreciate any help in the most simplest of terms.

    Thank you
    Luke
    Last edited by luke6843; 02-20-2009 at 01:49 AM.

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