Edit code to copy whole sheet

Hi,

Somebody very kindly gave me this code and everything works except i would like to copy the whole sheet not just the cells contents for a given range (I need the whole sheet formatting and all) at the minute its just the cell contents getting copied within a given range.

Help!

Please Login or Register  to view this content.

Thanks
Simon.

Please can somebody help me with this.

The problem is there is no notation in this code and as I am quite new to vba i dont really understand how i would change the code to enter the code you suggested. I can identify where the range is selected in the code but, there are other places where it looks like its selecting a range.

Where would i place suggested code to get it to work.

Thanks again

Simon Green