concatenate two columns

[matrixknow]

It is easy to concatenate the values of two columns in a new column. However can I do this in my code without touching the sheet.

Argument tree is the first_col and it should be the concatenation of two columns (1 + 4)

Call Get_Duplicates(duplicates, 1, 1, last_row)

Sub Get_Duplicates(ByRef duplicates() As String, first_row As Long, first_col As Long, last_row As Long)

 

[GlennUK]

What do you mean by "without touching the sheet"?

Do you have a Sub Get_Duplicates? Is it in here that you want the code? If so, then post the code!

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[matrixknow]

I mean not putting data in it (structure may not change).
A between solution is that I copied it in another temporarysheet.
I have the code Sub Get_Duplicates. One of the argument let you chose one column. I use this for the first search on duplicate. It works great ! The second search is on a new column that is a concatenation of two columns but that does not exist or may in the structure of the sheet. For this I created an temporarysheet. Pershaps not the best solution.
But then I can fill the argument with the column index.