+ Reply to Thread
Results 1 to 6 of 6

Paste from one sheet to last blank cell of a column

  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:

    Please Login or Register  to view this content.
    Last edited by Barking_Mad; 05-20-2015 at 04:35 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Paste from one sheet to last blank cell of a column

    Try this:

    Please Login or Register  to view this content.
    Notice how you can cut a lot of your code down by not selecting things
    !If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
    If I helped do this, then please show your appreciation by awarding rep points.
    <------ Button for that is over there

  3. #3
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Paste from one sheet to last blank cell of a column

    Alternatively, If there is nothing in B6 but you still want to protect the cells above you can use:

    Please Login or Register  to view this content.

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

    Re: Paste from one sheet to last blank cell of a column

    Hi,

    Thanks for the swift response Unfortunately there's a small error:

    "Object doesn't suppport this property or method"

    on this line:

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Paste from one sheet to last blank cell of a column

    Strange... Try this!

    Please Login or Register  to view this content.

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

    Re: Paste from one sheet to last blank cell of a column

    Thanks, that's just the ticket! Have some REP

    I shall go away and study the code and try to make sense of it!
    Last edited by Barking_Mad; 05-20-2015 at 04:34 AM.

+ 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. [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