VB help in finding error in code

[Excelnoub]

I have the following code but I need to find why it is telling me an error:

Please Login or Register  to view this content.

In my Sheet "Contracts" I need to get the info in column D then skip EFG then grab HIJ to add them in LMNO in my "Report" sheet.

The following doesn't work:

Please Login or Register  to view this content.

Please help

[Chippy]

Please Login or Register  to view this content.

I used the macro recorder to determine the range syntax for selecting/copying non-contiguous cells.

[Excelnoub]

Works perfect Thank :D