Thread: [Solved] Paste-As-Text macro
View Single Post
 
Old 11-20-2012, 01:30 AM
paulkaye paulkaye is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

I got:
Runtime error '1004': PasteSpecial method of Range class failed

I am often copying from outside of Excel - could it be that paste>values is a function only for pasting from copied Excel cells?
Reply With Quote