+ Reply to Thread
Results 1 to 3 of 3

Copy till first non-blank row and paste on first blank row

  1. #1
    Registered User
    Join Date
    02-16-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Copy till first non-blank row and paste on first blank row

    I'm working on this macro that copies data on sheet1 from A2:AI2 till the last non-blank row in the same range i.e. A:AI and paste it on sheet2 in the first blank row. However, my code keeps picking up A1:AI1 from sheet1 as well and pastes it on sheet2 just before the data that I actually want to paste. Here's my code:

    Please Login or Register  to view this content.
    Please help

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: Copy till first non-blank row and paste on first blank row

    I'm not a VBA guy so maybe I'm missing something but I don''t see where you're moving from sheet11 (the activesheet) to sheet2 in the code before you do the paste.

  3. #3
    Registered User
    Join Date
    02-16-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Copy till first non-blank row and paste on first blank row

    If you are on Sheet1 and you type "ActiveSheet.Next.Select" it moves to Sheet2...
    Can someone please help me to stop this code from copying A1:AI1?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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