CopyToRange

I am using the code bellow to filter a range and copy the results to Sheet1. How would I modify it to omit columns L and M from the copy. I only want to copy to D8:K8 and M8. The column headings are shown below, I want to omit Amount and Discount.

Date Order Number Customer Quantity Category Description Code Unit price Amount Discount Total

Please Login or Register  to view this content.

This is a guess. Without having your sheet to test with, I don't know for sure.

Please Login or Register  to view this content.

Makes sense, I'm real vba savay, thanks for the help.