I think because you are trying to put into 1 cell the info of several cells.

I don't think that could be possible.


"sam" wrote:

Sheets("Sheet2").Range("B29").Value = Sheets("Sheet1").Range("D8:D38").Value

Please Help

Thanks in Advance