Concatenate with code problem 1

[eon5]

Hi,

I need to concatenate some work, but can someone help me to get the code right. Recording the macro does not help me very much.

Sheet2.Range("b" & x1).Value = Sheet1.Range("c" & x1).Value CONCATENATE Sheet1.Range("b" & x1).Value

Thanks

 

[PHV]

Sheet2.Range("b" & x1).Value = Sheet1.Range("c" & x1).Value & Sheet1.Range("b" & x1).Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886