Return to page where code was started

[batchy]

Hi,

I have a VB code which is run from a worksheet called "Marco" this code duplicates the "Template" worksheet and re-names it in DDMM format.

The active cell appears on the newly created sheet. I would like the VB to return to the "Macro" worksheet to complete the 2nd Stage. Can anyone advise what needs to be tweaked with the below code?

Please Login or Register  to view this content.

[snb]

Please wrap your code in code tag (see the forum rules).
You shouldn't 'leave' the page in the first place (avoid activate & select in VBA)

[batchy]

Apologies now wrapped.

Can you advise where i should changing in code?