Results 1 to 3 of 3

Missing data after copy rows data from different worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    17

    Missing data after copy rows data from different worksheets

    Hi,
    I have attached my file for reference.
    Can anyone help me to check what is my mistakes?
    Thank you.

    Sub CopySheets()
         
        Dim ws As Worksheet
        Dim lastrow As Long
        
        Application.ScreenUpdating = False
         
        For Each ws In Sheets(Array("LQ80", "LQ100", "LQ144A"))
        lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row + 1
            
            With ws
                .Range("A8:M" & CStr(lastrow)).Copy
                Worksheets("Final").Range("A" & CStr(lastrow)).PasteSpecial (xlPasteValues)
            End With
        
        Next ws
         
        Application.CutCopyMode = False
        Application.ScreenUpdating = True
         
        Columns("K:K").ColumnWidth = 9
        Columns("L:L").ColumnWidth = 18
        Columns("M:M").ColumnWidth = 28
        
        Range("A1:J1").Select
        
    End Sub
    I'm sorry. I reattached my workbook.
    Last edited by davesexcel; 04-17-2013 at 09:25 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