Thanks anish.
-----Original Message-----
From: Anish Shrivastava
Sent: 14/07/2011, 10:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Want to copy two rows in all sheets except few
Hi Ajay,
Attached please find the updated sheet with rows copied in each sheet.
Below is the code I used.. (It might look amature, as I am new to VBA) :)
Sub copy_rows()
Dim sht As Integer
For sht = 5 To Worksheets.Count
Sheets(4).Select
Rows("5:6").Copy
Sheets(sht).Select
Rows("5").Select
ActiveSheet.Paste
Next sht
End Sub
Let me know if it works fine.
Thanks,
Anish
On Thu, Jul 14, 2011 at 9:23 PM, Rakesh Joshi
<rakesh.ri...@gmail.com<mailto:rakesh.ri...@gmail.com>> wrote:
could you please let us knwo in which range or cell u want to paste this rows
in note31
On Thu, Jul 14, 2011 at 7:25 PM, MITTAL AJAY
<amit...@iocl.co.in<mailto:amit...@iocl.co.in>> wrote:
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<http://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<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>
To post to this group, send email to
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Rakesh Joshi
--
----------------------------------------------------------------------------------
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<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>
To post to this group, send email to
excel-macros@googlegroups.com<mailto: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
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
