PDA

View Full Version : Paste into every sheet but first



pcollins
12-02-2007, 02:39 PM
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?

RichardSchollar
12-02-2007, 03:20 PM
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