Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste range to all sheets after specified sheet
from sheet "templates"
copy range A1:f13 and paste all to each sheet after "templates" then from sheet "templates" copy range A14:f:45 then paste formats only to each sheet after "templates" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste range to all sheets after specified sheet
Any ideas? Tried putting this together but not working.... Sub Paste_to() Sheets("Ind Templates").Select Range("A1:F13").Select Selection.Copy x = Sheets("Ind Templates").Index For Each Sh In ThisWorkbook.Sheets If Sh.Index x Then 'Do something Range("A1").Select ActiveSheet.Paste End If Next End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste range to all sheets after specified sheet
I know you gave up a little information, but can you provide some more
information please? Before and after? The better the description of the problem, the better the description of the solution. Thanks, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "J.W. Aldridge" wrote: Any ideas? Tried putting this together but not working.... Sub Paste_to() Sheets("Ind Templates").Select Range("A1:F13").Select Selection.Copy x = Sheets("Ind Templates").Index For Each Sh In ThisWorkbook.Sheets If Sh.Index x Then 'Do something Range("A1").Select ActiveSheet.Paste End If Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste all sheets into one master sheet | Excel Worksheet Functions | |||
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 | |||
Loop thru sheets copy and then paste in other sheet | Excel Programming | |||
copy from one sheet and paste into other sheets | Excel Discussion (Misc queries) |