Please copy what you have so far in your macro. I'm cross-posting this to
the programming group for more assistance.

"Bonbon" wrote in message
...
hi im tryin to create a macro to create new worksheets. This is basically
what is happening, i have 5 sheets mon-fri, n a weekly totals. i made a
macro
which inserts 5 more extra sheets after the weekly totals, and pastes the
outlines on the new sheets. It worked =), however it doesnt work the
second
time, it sort of overlaps and theres problems. Does anyone know how to
solve
this?

Also i have came accross another problem which is naming the sheets. I
wanted to create a macro which renames a sheet by simply copying the data,
e.g. the date is M-14.02.06 , n the sheet name is M-14.02.06.
Again it worked, but wouldnt work for the other sheets, it says theres a
problem because not all sheets are named 'Sheet1'. Does anyone know how to
solve this?

Any help would be hugely appreciated, and thanks in advance =)