rizwanulhasan
New Member
- Joined
- Jan 1, 2022
- Messages
- 16
- Office Version
- 2021
- Platform
- Windows
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.
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.