Paste with destination formatting error

[rizwanulhasan]

Hi,

I tried using the below VBA to enable paste with destination formatting and infact it works.

Sub PasteAsValue()

ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False

End Sub



However, the copy and paste is possible only for external apps and i cannot copy and paste any content within the workbook. If i do, below is the error received:

Run-time error '1004':
PasteSpecial method of Worksheet class failed.


Can someone resolve this issue?

Thanks in advance.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Paste with destination formatting error
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.