Concatinating using VBA

Using VBA, I am trying to concatenate 2 columns in one workbook and then apply these concatenated values with a space in between the values in each column to a single column in another workbook. In other words:

The workbook "ORDERS" has columns J and K that contains first and last names respect. I want to join each J and K with a space separating them into column J of the workbook "TEMPLATE" such that this column J will read "FirstName LastName" for each row until the last.

Originally I was going to use:

Please Login or Register  to view this content.

This produced an error at the firstname assignment.