Concatenation problems...
 

Hi

I've been trying to figure out an efficient code to solve this
challenge:


*Step1:* I make a random selection of cells
*Step2:* The Vba code loops through every cell of this selection, and
extracts only cells with unique values.
*Step3:* These unique values are assigned to one cell ( ex. A1 ),
separated with commas - 123,456,789 aso.... also - I need all the
unique values concatenated into one string, separated with commas.



I really hope someone can help me out on this.........


Hojo
Norway


--
hojo
------------------------------------------------------------------------
hojo's Profile: http://www.excelforum.com/member.php...o&userid=30082
View this thread: http://www.excelforum.com/showthread...hreadid=497622

Concatenation problems...
 

I have an Addin that does exctly that (along with a bunch of other stuff).
Send me your e-mail address and I will send you the addin...
--
HTH...

Jim Thomlinson


"hojo" wrote:


Hi

I've been trying to figure out an efficient code to solve this
challenge:


*Step1:* I make a random selection of cells
*Step2:* The Vba code loops through every cell of this selection, and
extracts only cells with unique values.
*Step3:* These unique values are assigned to one cell ( ex. A1 ),
separated with commas - 123,456,789 aso.... also - I need all the
unique values concatenated into one string, separated with commas.



I really hope someone can help me out on this.........


Hojo
Norway


--
hojo
------------------------------------------------------------------------
hojo's Profile: http://www.excelforum.com/member.php...o&userid=30082
View this thread: http://www.excelforum.com/showthread...hreadid=497622

Concatenation problems...
 

Shure, here it is.....

'hojo' )



Hoj

--
hoj
-----------------------------------------------------------------------
hojo's Profile: http://www.excelforum.com/member.php...fo&userid=3008
View this thread: http://www.excelforum.com/showthread.php?threadid=49762