Pasting in VBA

Hi Carey

PasteSpecial is a method of the Range object and is just one of the ways of pasting data into a workbook.

Although the Range method does not allow the Paste method, the Sheet method does which means as an alternative to using PasteSpecial is to use the code below:

Sub CopyPaste()

Range("A1:A20").Cut
Range("B1:B20").Select
ActiveSheet.Paste

End Sub

Hope this helps

Carlos