concatenate values 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)

It should be a number of a virtual column.

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)

[matrixknow]

=A10 &" "& AN10
=A11 &" "& AN11
=A12 &" "& AN12

When I type the first concatenation he shows the correct result. If I drop down to copied the formula, however he change the reference of the cells but I got the result of the first row

89589677 89589677
89589677 89589677
89589677 89589677
89589677 89589677

[matrixknow]

hoi, I thought it was a programming question but it was not.
It was a basic excel matter.
You need to go to Tools > Options > Calculation from manual to automatic.