Copy and Paste error - multiple selections?? HELP!

[cbowman]

OK, I am very new to macros so I am not sure what I am doing wrong in the code below. I get the following error message: Run-time error '1004': That command cannot be used on multiple selections." ray: Do I need to use totally different code, or should I change the code to work around the error? Interesting is the fact that this works fine on Excel 2001 for the Mac, but that is the only version on either platform that it works on.

Thanks in advance for any help.

Sheets("QPM_Database").Range("D:D,F:F").Copy
Sheets("QPM_ReportData").Paste Destination:=Worksheets("QPM_ReportData").Range("A:A,B:B")
Sheets("QPM_Database").Range("C:C,B:B,V:V").Copy
Sheets("QPM_ReportData").Paste Destination:=Worksheets("QPM_ReportData").Range("C:C,D:D,E:E")

 

[HalfAce]

Hi cbowman,
I've run into this with the PasteDestination statement too. The way I work around it is to change the code to something more like:

Sheets("QPM_Database").Range("D:D,F:F").Copy
Sheets("QPM_ReportData").Range("A1").Select
ActiveSheet.Paste

And go on from there.

Hope this helps.

 

[Iridium]

Any use?

http://j-walk.com/ss/excel/tips/tip36.htm

HTH

 

[HalfAce]

Hey Iridium,
Don't know if cbowman can use it but I sure can!
Thanks.

 

[cbowman]

Thanks Iridium,
I have not had a chance to try it out but it looks like a logical solution.
cbowman