Thread: Macro - Copy row and paste on all tabs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wigi Wigi is offline
external usenet poster
  
Posts: 396
Default Macro - Copy row and paste on all tabs
Hi

Dim i As Integer
For i = 2 To Sheets.Count
Sheets("sheet1").Rows(4).Copy Sheets(i).Range("A1")
Next


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"masterbaker" wrote:

I'm looking for an easy macro that copies row 4 from sheet1 and pastes data
(column headers) in Row 1 on all the other tabs. The number of tabs
fluctuates.
Reply With QuoteReply With Quote