Mike, good effort but there is a serious drawback. If you need to
limit the number of sheets to say 3, you would, in all probability,
want to leave all the existing sheets intact at the end of the day.

The code sadly deletes one of the 3 and replaces it with a new one. The
sheet count remains 3 but the composition has fatally altered. I have
tried a few things to no avail to cure this. It's all a question of
ALMOST there but NOT QUITE.

Anyhow, thanks for your input.

David.


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=473686