Get Worksheet tabs to automatically named?

For an invoicing spreadsheet, I want a macro assigned to a button that will print an invoice, update 2 sheets of data with what was invoiced and copy and rename these updated sheets with the invoice number.


I think I have it all figured out EXCEPT how to get the naming of these sheets. I found some code online that goes like this:

Please Login or Register  to view this content.

(found here:http://www.mrexcel.com/td0123.html)

I can't seem to get this code to work. In VB editor, I've pasted this in, but either get no results, "argument not optional" errors...basically not the result I want.

How can I get this code to work? Also, anticipating this macro to be run several times, is there going to be a problem with previously generated worksheets getting renamed?

Hope I made myself understood. And any good recomendations for a poor student looking to teach themselves more on VBA?

Thank you!

There are three sheets, each with their name to be in different relative cells. This is the code I used:

Please Login or Register  to view this content.

Looking at this now, I suppose I could remove the Sheets("xXxXxXx").Select and just have them automatically renamed; might make for a faster/more visually pleasing operation.