Putting speech marks and comma after pasted range

Martynrbell

New Member
Joined
Apr 11, 2016
Messages
35
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,814
Have you tried

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

Forum statistics

Threads
1,082,587
Messages
5,366,485
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top