Macro for copying the contents of a cell to the Windows clipboard

**isabelle r** · 01-09-2013, 08:22 PM

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.

**rollis13** · 01-10-2013, 02:53 AM

**isabelle r** · 01-10-2013, 10:42 PM

Originally Posted by rollis13

Infact, they shouldn't be there. The quotation marks are there just because of the line breaks. How is your concatenation formula ? can you rearrange it ?

The formula is:

=A1&" "&A2&"

"&A3

**rollis13** · 01-11-2013, 02:29 AM

Why couldn't your formula be like this: =A1&" "&A2&" "&A3
This doesn't have line breaks and doesn't add quotation marks to your copy/paste.

**isabelle r** · 01-11-2013, 09:37 PM

I actually need the line breaks, the file generates an email, which needs different paragraphs separated by a line break.

**snb** · 01-12-2013, 02:49 AM

You do not have to copy to use the contents of a cell in Excell.
Please tell us what the ultimate goal should be and we can suggest mucht simpler 'solutions'.