how to close a workbook without saving a individual worksheet?

Hi

I am a beginner in VB or Excel. I am doing some data entry stuff in my company.

here is my problem:

I have 2 work sheets in the workbook. my code changes the 1st sheet and adds new information to the 2nd sheet. I want to close the workbook without saving the sheet1 (I want to save the sheet2).

I used this code: activeworkbook.close savechanges:=false but this applies to whole workbook.

Can anyone help me in solving this problem?

Can you give the exact code to copy a sheet into a new sheet in the current workbook?


I tried this : sheet1.copy after:="sheet2" ............................
........................
........................
sheet2.delete

but it is resulting in an "object required" error