Copy a single worksheet range to new workbook

[dareeldill]

Im using the macro to copy a single page from a workbook to a new workbook.

I'm using this macro:

Please Login or Register  to view this content.

The problem is I don't want to copy the entire sheet. Only a select range.

In the attached example, I would like to only include range A1-G19.

Any assistance would be greatly appreciated.

[davesexcel]

Please Login or Register  to view this content.