Hi,
Its about 5 years since I did any VBA. How do I copy the contents of one worksheet into another including formats and values ? Here is what I have so far. Thanks
Kaps
Sub copy_sheet()
ActiveSheet.CopyWith ActiveWorkbook .SaveAs Filename:=Environ("TEMP") & "\New1.xls"...