Dear all


i have the following code

.Range("C" & Rw).Value = Wks.Range("AN" & i).Value
which basically puts the value of Column "AN" into Column "C" of another sheet.

I would like to also put values of Column "L" of the same sheet in "C" with the pipe | symbol separating those two values.

Can you help ?