Results 1 to 5 of 5

Append to Last column

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2009
    Location
    boston,ma
    MS-Off Ver
    Excel 2003
    Posts
    18

    Append to Last column

    I'm looking to append data from Column A in sheet 8 to the next open column in sheet 7. I know how to append rows, but not columns...

    This is what I have

    Sub AddtoMaster()
    Dim iLastColumn As Long
    
    ThisWorkbook.Sheets("Sheet8").Range("a:c").Copy
    ThisWorkbook.Sheets("Sheet7").Select
    iLastColumn = ThisWorkbook.Sheets("Sheet7").Column.Count
    Range("A" & iLastColumn).End(xlUp).Offset(1, 0).Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    
    
    End Sub
    I know this is most likely totally off, but as you can tell I based it off of a macro I used to append rows.
    Last edited by highwyre237; 09-25-2009 at 03:52 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