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])"