Solved: MisMatch error on joining two statements

[YellowLabPro]

I am looking to create a string and maintain certain formattting w/in the string. Is what I am trying to do legal, if so, where is my error here?


Range("J11").Value = WorksheetFunction.Proper(company & Chr(32) & season & Chr(32) & year) And _
UCase(store & Chr(32) & Format(Date, "m-dd-yy"))


thx

[Bob Phillips]

Doug,

Use & not And.

And is a logical opeartor, & is a text concatenator.

[YellowLabPro]

Thanks Bob,
needed to know the difference between the two.