Concatenation problems...

  • Thread starter Thread starter hojo
  • Start date Start date
H

hojo

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop help 6
Concatenate Text Strings over Array 8
Insert Concatenate formula in Cell 8
Concatenate anyone? 11
concatenate cell.value 5
concatenate locale bug? 8
Remove Trailing Comma 1
De-concatenate but maintain relationship/record structure 3

Back
Top