clear contents macro

[buckshot]

Hello all
I have a macro in my worksheet that is activated by a button.It copies the sheet to next day,increases invoice number by 1 and clears contens in specific cells.Right now it clears the contents in the cells of the sheet that is being copied.I would like to clear the contents of those cells in the new sheet.Thanks in advance

Please Login or Register  to view this content.

[romperstomper]

Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

[buckshot]

Thanks.Works great