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.

Please Login or Register  to view this content.

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

Here it is:

Enclosed is the worksheet and its code and examples. If you debug it you see that the concatenate is working all right but the issue is in that statement, I do not know why, because it works in other functions that I have created previously.

I could not upload the file, because it exceeds the limit for the forum. So I add further information to understand the code enclosed here.

There are two sheets, the first one is named "BDD" and the second one is named "GENERADOR DE LISTAS DE CORREO" where there is a button that executes the private sub CommandButton2_Click(). Finally, you should put in the column A from the worksheet "BDD" all the e-mail addresses in the differente rows starting from row 1 to n consecutively. If you click on the button on execution, you can see the error. If you debug it and brake on the specific line, you can see that everything is being done properly but assigning the value to the cell.

Please let me know if there is any question.

Please Login or Register  to view this content.

alejojauregui

Please do not ignore a moderators request

rylo asked you to do 3 things. You have done 1 of them.
Ignoring rylo's other 2 requests may see your thread closed

Your reply also breaks one of the rules that you were asked to fix in your 1st posting

Now Please take a couple of minutes and read the Forum Rules then wrap your VBA code (Rule 3)

Originally Posted by alejojauregui

Thank you. I will try to do what you just told me.

Regards,

Alejandro J.

I have edited your posts because you can no longer do so. Please read the Forum Rules which explain the correct format of Thread Titles & the use of Code Tags