VBA to concatenate variables in a formula and separate by a space

[General Ledger]

Dear All,

How do I get a space to appear between the two concatenated values?

LineText = "=" & CustNameReference & InvoiceReference

The two variables are cell addresses:
CustNameReference = $A$1 = John Smith
InvoiceReference = $B$1 = 123

When I execute the code

Range("C1") = LineText

I want the formula in C1 to appear like =$A$1&" "&$B$1
so the result is John Smith 123.

As it is now, the result is John Smith123 (no space between the name and invoice).

Thanks,

GL

 

[VoG]

Like this?

LineText = "=" & CustNameReference & " " & InvoiceReference

 

[General Ledger]

VoG,

Thanks for pointing me in the right direction. I was thinking I needed to use Chr(160) to get a space.

I played with your proposed code and ended up with:

LineText = "=" & CustNameReference & "& "" "" &" & InvoiceReference

I won't try to understand how many &'s and pairs of quotes were used. Knowing it works is all I need for now.

GL