On Aug 21, 12:55 pm, Sean wrote:
On Aug 21, 11:41 am, "Zone" wrote:





Change the ActiveSheet.Copy line like this:

ActiveSheet.Copy after:=ActiveSheet

"Sean" wrote in message

ups.com...

On Aug 20, 9:54 pm, "Zone" wrote:
Spot on James. One final tweak. It places the new sheet at the end of
my sheet list, how would I place it just to the right of my original
sheet?

Thanks- Hide quoted text -

- Show quoted text -

Thanks for your help James- Hide quoted text -

- Show quoted text -

James can I test your knowledge again? If an attempt was made to
create a sheet with the same name / date (which I can't have). How in
this instance if it happened could I cancel out of the macro with a
message box saying "You have already created this week"?

Thanks