Sandeep, I did not immediately see that you needed copies of another
> sheet. Maries has you.
>
> Asa
>
> -Original Message-
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Saturday, March 31, 2012 12:40 AM
> To: 'excel-macros@googlegroups.com'
> Subject: R
u needed copies of another
> sheet. Maries has you.
>
> Asa
>
> -Original Message-
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Saturday, March 31, 2012 12:40 AM
> To: 'excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Macro f
$$ Macro for 100 sheets
Hi,
Try Below Code,
Sub Sheet1Multiplecopy()
Dim i As Integer
i = 1
For i = 1 To 100
Sheets("Sheet1").Select
Sheets("Sheet1").Copy After:=Sheets(i)
ActiveSheet.Name = i
Next
End Sub
Regards,
MARIES.
On Sat, Mar 31, 2012 at 10:11 AM, wrote
t; To: 'excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Macro for 100 sheets
>
> Hi Sandeep,
>
> sheets.Add count:=100
>
> Check help for additional options.
> Asa
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel
Sorry, Sandeep, I did not immediately see that you needed copies of another
sheet. Maries has you.
Asa
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Saturday, March 31, 2012 12:40 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Mac
Hi Sandeep,
sheets.Add count:=100
Check help for additional options.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chhajersand...@gmail.com
Sent: Friday, March 30, 2012 11:11 PM
To: excel-macros@googlegroups.com
Subject: $$
Hi,
Try Below Code,
Sub Sheet1Multiplecopy()
Dim i As Integer
i = 1
For i = 1 To 100
Sheets("Sheet1").Select
Sheets("Sheet1").Copy After:=Sheets(i)
ActiveSheet.Name = i
Next
End Sub
Regards,
MARIES.
On Sat, Mar 31, 2012 at 10:11 AM, wrote:
> Dear excel guru,
>
> I want a macro to
