How to copy the contents of cell without control characters

[aparna]

Every time I copy the contents of an excel cell it copies the text box and some formating characters alongwith the contents.

Is there anyway I can copy the contents of a cell as pure text either through a macro or VBA.

 

[AgentSmith]

Did you paste it into the sheet's module or a stand-alone module? I suggest you use the latter, otherwise you'll be calling it using something like "Sheet1.SetClipboardText".

Oh yes, you should add

Set d = Nothing

before the "End Sub" too!

 

[aparna]

Hi Mike,
Thanks so much for the code... but I am not able to run this. How do I run this . I have pasted this as VBA code in the current sheet. But I am not able to see this either as a macro or a VBA application.
aparna

 

[AgentSmith]

If I were you I'd drop it into a separate Module, rather than the Sheet.