Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

concatenate two columns

Status
Not open for further replies.

matrixknow

IS-IT--Management
May 3, 2007
78
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)
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top