Quote Originally Posted by snb View Post 
msgbox Join(Array(.Cells(I, 1), .Cells(I, 2), .Cells(I, 4).text, ValD, ValE, .Cells(I, 6).text)
Hi VBAX Guru,

Thanks a lot for helping me out

your string must be added where? and should replace what please?
THANKS again...