Macro to Paste Text only

[Crawfy]

I have a protected workbook with various cells unlocked for editing.
I would like to be able to add a macro to enable me to paste just text only into these cells when i choose to.
I have used the VBA code below but it does not work all the time.

Please Login or Register  to view this content.

If i select text from outside the workbook then the text will be pasted.
If i copy text from cells within the workbook i receive a Runtime error '1004':
PasteSpecial method of Worksheet class failed

Any ideas?

[mjr veverka]

This 'PasteSpecial' method is the method as it applies to the 'Worksheet' object, not to the 'Range' object. 'Cells' are 'Range' type objects.
There is a different syntax for this, e.g.:

Please Login or Register  to view this content.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post