Macro for copying the contents of a cell to the Windows clipboard
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:
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.
