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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.