Results 1 to 14 of 14

copy range from multiple sheets and paste to one sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Zuerich, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    15

    copy range from multiple sheets and paste to one sheet

    Hey guys,
    i am having trouble with the following taks:
    I need to copy a row of five cells from every sheet in the wb (same cells every sheet) to one new sheet. The rows should appear in cells B2:F2 and downwards.
    I think i got the copy part right but i habe no idea how to do the paste part.

    Sub CopyCells()
        Dim ws As Worksheet
        For Each ws In ActiveWorkbook.Worksheets
                With ws.Range("H1:S1")
                    .Copy
                End With
        Next ws
    End Sub
    Thanks for your help!
    Last edited by arlu1201; 04-04-2013 at 05:36 AM.

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