Copy past sheets from the work book as it is

Hi all,

I was wondering if some one would help me with small changes in the program. I have code that does this simple job i.e after report got run in the template . I need only specific sheets to be saved to the specified folders so program is doing fine but at the time of creating a copy.it is not coping graphs or charts as it is. and more over it is copying and pasting from cell 1 I don't want that way , I want it to be dynamic , the area that was used in my template the same area needs to copy and past.

can that be happened ?. below is the code for your reference.

Please Login or Register  to view this content.

Hi Dave.

thanks for your advice . but when I am trying with above line I am seeing errorr message .