Adding line break

Hi, how to add a line break so the values are in the same cell showing vertically. This is the code im using but it doesnt seem to work. Thanks

Please Login or Register  to view this content.

Hi biznez, could you add an example workbook for this?

Originally Posted by berlan

Hi biznez, could you add an example workbook for this?

Hi Berlan, here is a sample. I just had to change the code around to reflect the sample file. Thanks

Thanks for providing an example. In the code in #1, try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Would that work?

Originally Posted by berlan

Thanks for providing an example. In the code in #1, try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Would that work?

no that did not work

For your example workbook, you could also try a formula alternative:

Please Login or Register  to view this content.

Let me know if that would do the trick.

Key thing, if I understand your question, is to include the char(10) for a new line between the values from Col. A and B, provided that you have enabled the "wrap text" property.

Originally Posted by berlan

For your example workbook, you could also try a formula alternative:

Please Login or Register  to view this content.

Let me know if that would do the trick.

Key thing, if I understand your question, is to include the char(10) for a new line between the values from Col. A and B, provided that you have enabled the "wrap text" property.

for example...basically this is how i want it to display in cell F1 using code

Please Login or Register  to view this content.

Ok, understood. For the example workbook, now try:

Please Login or Register  to view this content.

Originally Posted by berlan

Ok, understood. For the example workbook, now try:

Please Login or Register  to view this content.

Thats exactly what i wanted...thank you so much!! now i have to understand your code

You're welcome, and thanks for the rep