I am facing a challenge that I can't seem to get my head around. I need to create an array in excel that takes the values from two columns, cast them into strings, concatenate the strings, and then sort in numeric order to delete duplicates.
I can do the delete duplicates via vb code
For x = 1 To counter
a = ActiveSheet.Range("h" & x).Value
'MsgBox ("a=" & a)
y = x + 1
c = ActiveSheet.Range("h" & y).Value
' MsgBox ("C=" & c)
If a = c Then
If a = "" Then
x = x - 1
What I have currently tried is having a cell with =h1&g1 but since the values are numeric it is messing it up rather than concatenating the columns. For example 41638 and 4 are resulting in 414110. I can't see how that is happening, so I figured casting would fix it.