Hello,

I have a simple question regarding a way to copy cell contents to the Windows clipboard for use in other applications.

I have a cell X1 which consolidates information from different cells using a simple concatenation formula. I then want have a macro assigned to button that copies this cell (including formatting such as line breaks, etc.). The macro is simply:

Code:
Range("X1").Copy
This works fine, except that when I paste the text into Notepad for example, the text is preceded and followed by quotation marks: i.e. it pastes "Hello" instead of Hello.

Is there something I could change to the macro so that these undesirable quotation marks are not added to the text I'm pasting?

Thanks in advance.