Copy & Saving individual work sheets from work book

  • Hi I have a master work book with a master sheet. The code I use creates and names individual work sheets. The second code I use save these individual work sheets to a designated folder. The problem I have, is that the VBA stopped saving the sheets with the following message appearing ' An error has occurred. Error number 1004. Error description= copy method of Worksheet class failed' I have attached the code Richard

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!