Results 1 to 6 of 6

Paste from one sheet to last blank cell of a column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Paste from one sheet to last blank cell of a column

    Hi,

    I've seen solutions to this but can't quite work out how to get mine to work just as I wish. Basically I need a macro to copy a range from one sheet to another, but the checking for an empty row in column B (before pasting) should start from B6 (as there are blank cells above that need to remain blank). Unfortunately I can't get it to work properly. The offset works the once, but then each subsequent paste leaves another 3 blank lines before pasting the info across. Any help appreciated!

    The code I have is as follows:

    Sub CopyAndPaste()
    Sheets("Absences_List").Select
    Range("A2:T200").Select
    Selection.Copy
    
    Sheets("Absences_Details").Select
    Range("B" & ActiveSheet.Rows.Count). _
    End(xlUp).Offset(3, 0).Select
    ActiveSheet.Paste
    Range("B" & ActiveSheet.Rows.Count). _
    End(xlUp).Offset(3, 0).Select
    'Sheets("Status_Change").Select
    'Range("B6:M200").Select
    'Selection.ClearContents
    '[B6].Select
    Application.CutCopyMode = False
    End Sub
    Last edited by Barking_Mad; 05-20-2015 at 04:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy / Paste range from one sheet to another, if cell in column A is not blank
    By Tapyr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2014, 09:18 AM
  2. Find blank cell, then paste entire row onto another sheet
    By Misterturtle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 05:34 PM
  3. [SOLVED] if column N blank, trigger email and paste to different sheet
    By fabrecass in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2013, 11:16 AM
  4. Copy Data from Column and Paste to Next Blank Column on 2nd Sheet
    By adammark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2010, 11:15 AM
  5. Copy from one sheet and paste into another shee int the blank cell
    By karinos57 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2009, 05:49 AM

Tags for this Thread

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