copying sheet with macro

[mcrmike]

On my worksheet (totals hours worked each day for all employes) I have
macro assigned to a button (update) on the worksheet which copies th
sheet, deletes all data and then updates the dates to the next week
The problem is, when I click the button and it copies the worksheet i
always uses the original sheet (sheet1) instead of using the ne
updated sheet (sheet2,3,ect.) when I run the macro each additiona
time. I understand that the macro is referencing sheet1, but I don'
know how to make it reference the active sheet. Help would be greatl
appreciated. Thanks

 

[Beto]

On my worksheet (totals hours worked each day for all employes) I have a
macro assigned to a button (update) on the worksheet which copies the
sheet, deletes all data and then updates the dates to the next week.
The problem is, when I click the button and it copies the worksheet it
always uses the original sheet (sheet1) instead of using the new
updated sheet (sheet2,3,ect.) when I run the macro each additional
time. I understand that the macro is referencing sheet1, but I don't
know how to make it reference the active sheet. Help would be greatly
appreciated. Thanks.

Search in your code the references to sheet1 and change it for ActiveSheet.

Regards,

 

[mcrmike]

Thanks, Beto it worked fine, things are good with the world again.