Help modifying code please.

Hi there,

The code below i have used before to extract the worksheets named in the array to a new workbook and then save the workbook with a timestamp.

I need to now modify this code to instead copy the whole worksheet over but just copy a certain range i.e. "A1:AY250". This is the same range for each sheet.

This code is not my own and i take no credit for it, i found it on the web.

Please Login or Register  to view this content.

Yea the code copies the sheets specified and copies them directly into a new workbook.

I am only needing two sheets to be copied.