Consulting

Results 1 to 2 of 2

Thread: Paste into every sheet but first

  1. #1
    VBAX Regular
    Joined
    Nov 2007
    Location
    Unfortunately Maryland
    Posts
    15
    Location

    Paste into every sheet but first

    Im trying to copy the first row from the first sheet in a workbook and paste it into every sheet in the book except the first sheet, how do I not paste it into the first sheet?

  2. #2
    VBAX Contributor
    Joined
    Aug 2006
    Location
    Hampshire, UK
    Posts
    140
    Location
    Hi

    Perhaps:

    Sheets(1).Rows(1).Copy
    For Each ws In ThisWorkbook.Worksheets
       If ws.Name<>Sheets(1).Name Then
          ws.Range("A1").PasteSpecial 
       End If
    Next ws
    Richard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •