Union question

[ToddG]

I have a string similar to the following (the underscore
is a blank space):

_49 x 1.5 Total

49 and 1.5 come from ranges in a worksheet

I need to assign this string to a variable. I tried the
following, but I can't get it to work (doesn't seem to
like the blank spaces):

NewBF = Union(" ", Sheets("PanelChange").Range("C1"), _
" " x ", Sheets("PanelChange").Range("D1"), " ", "Total")

Any advice on this?

TIA,

Todd

 

[Bob Phillips]

NewBF = " " & Sheets("PanelChange").Range("C1") & _
" x " & Sheets("PanelChange").Range("D1") & _
" " & "Total"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ToddG]

Thanks once again Bob. Thought i'd have to use the Union.

 

[Bob Phillips]

No, Union joins ranges not strings

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)