In the attached Workbook I have a macro that copies a master sheet and then renames it according to a range in the 'Ctrl' sheet. Unfortunately before all the sheets can be created the memory fills up and the macro breaks.

If someone could tell me how to clear the memory after each sheet has been created it would be much appreciated! Also if possible it would be great to add some lines that check if the number of names in the list is longer than the existing no. of sheets, if so continue, if not exit.

Any help much appreciated.

Best

Alex