Object dosen't support this property or method?

[3link]

I'm trying to set-up two macros between two workbooks. The workbook to be copied will have a macro that resembles (simplified for clarity):

Sub Button1_Click()
Range("A1:A10, C1:C10, E1:E10").Copy
End Sub

Notice how columns B and D are not copied.

The destination workbook's paste macro looks like this:

Sub Button1_Click()
Range("A1:A10, C1:C10, E1:E10").Select
Selection.Paste
End Sub

I keep getting a "Object dosen't support this property or method" error. Any solutions?

 

[Andrew Poulsom]

A Range doesn't have a Paste method.

 

[3link]

How would I have to code it to paste the cells I had just copied from the other workbook? I can't find a solution anywhere.

 

[Andrew Poulsom]

You can't copy/paste discontiguous ranges like that. If you do the pasted data will be contiguous.

 

[3link]

I see. Thank you.