VBA keeps giving errors on PasteSpecial

**Inter** · 04-11-2012, 09:40 PM

Hello

I keep getting an error when the script gets to PasteSpecial and I have no idea why.

The script is included here.

Please Login or Register  to view this content.

Any suggestions of a constructive nature will be warmly received.

Thanking you in advance.

**Mallycat** · 04-11-2012, 11:23 PM

PasteSpecial takes a number of arguments. You don't have any. I think the correct syntax is "selection.pastespecial" too, not sheets(2).pastespecial. Turn on the macro recorder, copy and paste something using the paste special you want to use, and then check the code.

Also, you shouldn't call VBA VB Script - that is something different.