maybe insert in you code:

.CC = c.Offset(0,1).Value & ""