Save as Macro

[jsantos]

Hi Guys

I am having some problems when putting a macro together that is meant to refresh a used workbook and then save it.
What i am doing is in the end of the week i finish a workbook, and i am doing a macro that clears all the old info and once clear i am trying to save it as "Ticket control week(&Menu!F2).
So the name of the fresh workbook is a set name (Ticket Control Week)with the contents from "F2" in the Menu Tab concatenated.
Could you tell me where i am going wrong, please

Code as follows

Many thanks

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[jsantos]

Hi ProtonLeah

Thanks a million for your help.
Very much apreciated
Regards
Jsantos