Prevent source formatting when copying both from web and same sheet.

[Alwexis]

Hello

Im trying to prevent change formatting of my cell when user is copying (ctrl+v) a value from web/from same sheet.

Im using following VBA code:

Sub PasteAsValue()
ActiveSheet.PasteSpecial Format:="General", Link:=False, DisplayAsIcon:=False
End Sub

It works really good when pasting from web. However when pasting from cell to cell i get the following error:

"pastespecial method of range class failed "

Can someone give me a hint how to improve my VBA to prevent this error?

Many thanks

Alex