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" |
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 |
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 |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com