Hello:

I am looking for VBA code that will take a range of cells B2:E2, from sheet 2, concatenate them with a space between each cells text string, and paste the result into cell A2 on sheet 1.

I hope I have explained this well enough, but please feel free to ask for clarification.

I greatly appreciate the assistance.

David