RE: $$Excel-Macros$$ Error in Macro Code

2010-12-08 Thread Dave Bonallack
o the first range, since it contains a different number of cells? Is it always 11 cells more than the range of data in Columns A & B? Regards - Dave. Date: Wed, 8 Dec 2010 13:47:33 +0530 Subject: Re: $$Excel-Macros$$ Error in Macro Code From: vebhav.j...@gmail.com To: excel-macros@googlegrou

Re: $$Excel-Macros$$ Error in Macro Code

2010-12-08 Thread vebhav jain
omate the process. > Regards - Dave. > > > -- > Date: Wed, 8 Dec 2010 06:51:01 +0530 > Subject: Re: $$Excel-Macros$$ Error in Macro Code > > From: vebhav.j...@gmail.com > To: excel-macros@googlegroups.com > > Can someone look into this and sugge

RE: $$Excel-Macros$$ Error in Macro Code

2010-12-07 Thread Dave Bonallack
t: Re: $$Excel-Macros$$ Error in Macro Code From: vebhav.j...@gmail.com To: excel-macros@googlegroups.com Can someone look into this and suggest me. On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote: Hello, Can you please help me in making this code in a standard format, instead of changin

Re: $$Excel-Macros$$ Error in Macro Code

2010-12-07 Thread vebhav jain
Can someone look into this and suggest me. On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote: > Hello, > > Can you please help me in making this code in a standard format, instead of > changing the code daily manually of the highlighted text. Thanks in Advance. > > Sub macro1() > ' > ' Macro1 M

RE: $$Excel-Macros$$ Error in Macro Code

2010-12-07 Thread Dave Bonallack
Excel-Macros$$ Error in Macro Code From: vebhav.j...@gmail.com To: excel-macros@googlegroups.com Hello, Can you please help me in making this code in a standard format, instead of changing the code daily manually of the highlighted text. Thanks in Advance. Sub macro1() ' ' Macro1 Macr

$$Excel-Macros$$ Error in Macro Code

2010-12-07 Thread vebhav jain
Hello, Can you please help me in making this code in a standard format, instead of changing the code daily manually of the highlighted text. Thanks in Advance. Sub macro1() ' ' Macro1 Macro ' ' Dim Z As Long Range("H2").Select ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-6],RC[-5],RC[-1])"

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

2010-12-07 Thread Rajesh K R
t; Sheets(CInt(mySht)).Select > End Sub > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De > la part de Rajesh K R > Envoyé : lundi 6 décembre 2010 17:13 > À : excel-macros@googlegroups.com > Obj

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

2010-12-06 Thread Daniel
lundi 6 décembre 2010 17:13 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ error in macro hi Danial Thanks for ur reply i tried ur code but it shows other error (subscript out of range) when selecting the page. pls tell me how to solve it. Regards Rajesh On 1

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

2010-12-06 Thread Rajesh K R
t) Then Exit Sub > Sheets(mySht).Select > End Sub > > Regards. > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De > la part de Rajesh K R > Envoyé : dimanche 5 décembre 2010 11:31 > À : ex

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

2010-12-06 Thread Daniel
& vbCr & myList) If Not IsNumeric(mySht) Then Exit Sub Sheets(mySht).Select End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Rajesh K R Envoyé : dimanche 5 décembre 2010 11:31 À : excel-macros O

$$Excel-Macros$$ error in macro

2010-12-05 Thread Rajesh K R
Hi Experts, How to solve my problem regarding run time error Sub Go2sheet() myShts = ActiveWorkbook.Sheets.Count For i = 1 To myShts myList = myList & i & " - " & ActiveWorkbook.Sheets(i).Name & " " & vbCr Next i Dim mySht As Single mySht = InputBox("Select sheet no to copy data for report." & vb