Hello everyone.
I'm trying to concatenate the data from Col "F", following by a ";" and paste the result in Cell "L2".
I tried several time without success.

This is my code:

Fila =6 'Info starts in F6
Do While Range("F" & Fila) <>""
Fila=Fila+1

I tried with
ActiveCell.Formula2R1C1="=Concat(Fila & ""; "")"
(obviously is wrong)

I want this as example:
in F6 = Perez, Ricardo
in F7 = Perez, Patricia
as result in L2= Perez, Ricardo; Perez, Patricia

Thanks. I'm a beginner with the VBA.