th seasies wasy is to manual go to each sheet selecting the sheet in the
vba project window and then tyhpe Cntl-A (select all) and press delete.
It only should take 2 minutes.

You can easily delete all the sheet by selecting all at once and
starting from scratch. remove the vba code. Then write a very simple
macro to create the sheets


for I = 1 to 50
sheets("sheet1").copy after:=sheets(sheets.count)

next i


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176984

Microsoft Office Help