Compile error As "Wrong number of argument or argument or invalid Property assignment

hi
here i have code that give the Compile error As
"Wrong number of argument or argument or invalid Property assignment

Please Login or Register  to view this content.

actually i want to close the WB which just copy past so save the WB and close the same
can u help me pl.

You missed the workbook name:

Please Login or Register  to view this content.

hi romperstomper
thanks u save my day it long day
i am learning the VB
can u help me for this one it also give me headache

Please Login or Register  to view this content.

here i am doing the copy past in same WB but inserting the sheet at end of all sheet

in anther ward iwant to create the new sheet name"yesterday" is the same copy of "today" sheet and create that one after the all sheet
and i have this button in "main"sheet.
thanks for any help