One other thing while it is on my mind. In the event that you do have over 49 worksheets. simply deleting a value will not remove that worksheet. We would need to write a few more lines of code for that. Let me know if that is needed or not. If it is I will need to know what worksheets in the workbook to not delete since I would write a loop to check all the values in D5 to D50 checking if there is a worksheet with the name or not. If there is a workbook name not in that list it would delete the worksheet. This can bring lots of problems though since when you delete a worksheet you cannot get the data back We could always write a backup program to pull all the data off that worksheet and store it in a temporary location incase in does get deleted. Hopefully we do not need to go that route since it will be a lot of work.

Let me know.