Try this
Sub PasteIt()
Sheets("Heading").Activate
Rows("5:6").Copy
For i = ActiveSheet.Index To Sheets.Count
ActiveSheet.Next.Activate
Range("A5").Select
ActiveSheet.Paste
If ActiveSheet.Index = Sheets.Count Then Exit Sub
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of MITTAL AJAY
Sent: Thursday, July 14, 2011 7:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Want to copy two rows in all sheets except few
Dear All,
I want to copy & paste special rows 5& 6 of sheet “Heading” to all the sheets
starting from “Balance Sheet” to “Note 31”
Can someone suggest code for the same.
शुभकामनाओं सहित,
अजय मित्तल,
वित्त प्रबन्धक
पाइपलाइंस मुख्यालय
टेलीफोन:0120-2448312
ई-मेल : amit...@iocl.co.in
This Message was sent from Indian Oil Messaging Gateway, Refineries HQ, New
Delhi, India. The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
