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")
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")
