Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Deba Ranjan
; >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest >> *Sent:* 11 June 2012 6:26 >> >> *To:* excel-macros@goo

RE: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Rajan_Verma
good Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ahmed Honest Sent: 11 June 2012 6:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate Problem. Rajan, 100

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Ahmed Honest
; > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest > *Sent:* 11 June 2012 6:26 > > *To:* excel-macros@googl

RE: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Rajan_Verma
Subject: Re: $$Excel-Macros$$ Concatenate Problem. Hi Deba, the same can be achieved without VBA let me know if you wish to have that. Just send me your file. I will send you the solution. On Mon, Jun 11, 2012 at 3:54 PM, Deba Ranjan wrote: Thanks.. Thanks

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Ahmed Honest
Dear -- I deleted the email when i read it for the first time, thinking this will be easily answered by the group. Anyways see attach i have created an example of your file which you sent. Thanks, On Mon, Jun 11, 2012 at 3:57 PM, Deba Ranjan wrote: > Ahmed ji..i think the file is alre

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Deba Ranjan
Ahmed ji..i think the file is already attached in this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest wrote: > . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Ahmed Honest
catAll(rngRange As Range) As String >> >> ConcatAll = >> *Join*(Application.Transpose(Application.Transpose(rngRange)), >> ",") >> >> End Function >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Deba Ranjan
o: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 11 June 2012 5:55 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Concatenate Problem. > > ** ** > > Thanks .very > > > > > Thanks & Regard

RE: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Rajan_Verma
:55 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate Problem. Thanks .very Thanks & Regards, Deba Ranjan P On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote: See attached sheet. On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote:

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Deba Ranjan
Thanks .very Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote: > See attached sheet. > > > On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI > wrote: > >> Dear Deba, >> >> Please try below UDF, See attached sheet.. >> >> *Function Concatenat

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread NOORAIN ANSARI
Dear Deba, Please try below UDF, See attached sheet.. *Function Concatenate_Deba(rng As Range) Dim cell As Range Dim str As String For Each cell In rng str = str & cell & "," Next cell str = VBA.Right(str, Len(str) - 1) Concatenate_Deba = str End Function * -- Thanks & regards, Noorain Ansari w