Macro that copy a cell but always adds an extra charachter??

Anybody please tell me how to use the activecell.copy or similar to copy the content of the cell without having Excel adding an cariage character mistiriously? It shows when I use CTR-V to paste into another program. If I copy and pase manually from the cell it is fine, but using the macro it is simply adding an extra character!!

Comments

: Anybody please tell me how to use the activecell.copy or similar to copy the content of the cell without having Excel adding an cariage character mistiriously? It shows when I use CTR-V to paste into another program. If I copy and pase manually from the cell it is fine, but using the macro it is simply adding an extra character!!:

I see what you mean.What you could do is in VBA insert a new UserForm and insert the following code:

Then you can setup your shortcut key to use CallMyCopy. Make sure the first code is put in the UserForm since the DataObject object is in the MSForms 2.0 Library.[blue][size=4][b]markyc[/b][/size][/blue][grey][size=2]I made a new friend today. Real or imaginary? Imaginary.[/size][/grey]