Re: $$Excel-Macros$$ amend in macro

2012-05-13 Thread Aamir Shahzad
> > End Sub > > > > Don Guillett > > Microsoft MVP Excel > > SalesAid Software > > dguille...@gmail.com > > > > From: Aamir Shahzad > > Sent: Saturday, May 12, 2012 2:40 PM > > To: excel-macros@googlegroups.com > > Subject: Re: $

Re: $$Excel-Macros$$ amend in macro

2012-05-12 Thread ╰» ℓαℓιт мσαнη
veSheet.Name = i > Next i > End Sub > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > From: Aamir Shahzad > Sent: Saturday, May 12, 2012 2:40 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ amend in macro

Re: $$Excel-Macros$$ amend in macro

2012-05-12 Thread dguillett1
PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ amend in macro error reflecting, see the attached snapshot. On Sun, May 13, 2012 at 12:13 AM, dguillett1 wrote: For i = 1 To inputbox(“how many”) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmai

Re: $$Excel-Macros$$ amend in macro

2012-05-12 Thread dguillett1
For i = 1 To inputbox(“how many”) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 1:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ amend in macro Dear Group, Following macro provided by anyone in th

RE: $$Excel-Macros$$ amend in macro

2012-05-12 Thread Asa Rossoff
[mailto:a...@lovetour.info] Sent: Saturday, May 12, 2012 12:06 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ amend in macro Sub Sheet1Multiplecopy() Dim s1 as worksheet, n as long, c as long c = worksheets.count set s1=worksheets(1) For n = msgbox

RE: $$Excel-Macros$$ amend in macro

2012-05-12 Thread Asa Rossoff
Sub Sheet1Multiplecopy() Dim s1 as worksheet, n as long, c as long c = worksheets.count set s1=worksheets(1) For n = msgbox("How many sheets do you want to add?) to 1 step -1 s1.Copy After:=s1 ActiveSheet.Name = n Next s1.select End Sub From: exce