new sheet named vba

[Sirishgreen]

hi,

I have the following code to create a new sheets based on a template. Then rename it based on the valuse entered into the text box on a form. However I am having trouble getting it to work properly it is creating 2 sheets and always replacing the last created sheet.

Please Login or Register  to view this content.

Any ideas?

Thanks
Simon Green

[royUK]

No code! I posted code to do this this morning

http://www.excelforum.com/showthread...73#post1934373

[Sirishgreen]

I have put the code in there now sorry about that.