Re: $$Excel-Macros$$ Make String From Range without any Loop

2011-12-30 Thread NOORAIN ANSARI
Good one Rajan.. On Sat, Dec 31, 2011 at 12:35 AM, Rajan_Verma wrote: > Hi Group, > > ** ** > > Want to share a useful method on group to make a delimiter separated list > without any loop after taking Input Range of One Column of One Row, it can > work on 255 Cells. > > Application.Trans

$$Excel-Macros$$ Make String From Range without any Loop

2011-12-30 Thread Rajan_Verma
Hi Group, Want to share a useful method on group to make a delimiter separated list without any loop after taking Input Range of One Column of One Row, it can work on 255 Cells. Application.Transpose need to be used once if Data is Vertical and if data is horizontal its need to be used Twice..