Issue with programming.

Hi guys,

I am doing a function in MS Excel, the function should concatenate e-mail adrresses separated by semicolons. I will put The e-mails in the column A from a worksheet named BDD. The VB code does not work properly, because when I tried to put the whole string on the content of the cell using either one of the following statements, I get an error message 1004 in execution.

'        ActiveCell.Formula = cadena_de_correos(5, Columna_1, Fila_1)
'        Cells(Fila_2, Columna_2) = cadena_de_correos(5, Columna_1, Fila_1)

Cadena_de_correos() is a string type function that creates a string with all the e-mails separated by semicolons and will return it.