concatenate cells

[comp23]

If I have data in columns a,b,c,d. How do I concatenate these values into one cell using vba. The hard part for me is that I want it to concatenate until it reaches an empty row. cheers.

[Steffen Thomsen]

Try

Please Login or Register  to view this content.