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?
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?
Hi
Perhaps:
RichardSheets(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