Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Doesn't work....
Any clues? Sub Macro1() ' 'copy range from template sheet Sheets("Ind Templates").Select Rows("38:50").Select Selection.Copy 'for each sheet in workbook after "ind templates" x = Sheets("Ind templates").Index For Each Sh In ThisWorkbook.Sheets If Sh.Index x Then 'paste the copied data 1row below the last row used Range("A365").Select Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Select Selection.Paste End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste range to all sheets after specified sheet | Excel Programming | |||
Line count in sheet determines paste range in another sheet | Excel Programming | |||
Line count in 1 sheet to determine paste range in 2nd sheet. | Excel Programming | |||
Paste range from one sheet to another | Excel Programming | |||
Find range in one sheet, then paste in the other (one by one) | Excel Programming |