Putting speech marks and comma after pasted range

[Martynrbell]

I have the following line of code

Worksheets("Sheet1").Cells(RowNo, ColNo).Copy Worksheets("Sheet2").Range("B" & (DstRowOffset + ColNo + 1))

I would like to paste the cell with "pasted cell",

CHR(34)&Value&CHR(34)&CHR(44)

Any one know how to do this ?

 

[mikerickson]

Have you tried

Worksheets("Sheet2").Range("B" & (DstRowOffset + ColNo + 1)).Value = CHR(34)& Worksheets("Sheet1").Cells(RowNo, ColNo).Value &CHR(34)&CHR(44)

 

[Martynrbell]

Thanks that worked.
I did try that but I must have messed it up some how