I have a workbook that I need to add a Worksheet called "CurWorkPad" to.

Right now I can insert a worksheet and it will come up named "Sheetx", where
x=a number that increments each time a sheet is inserted. I also have code
to rename a worksheet, but it requires you to know the current name of the
inserted worksheet.

Is there a way to insert a new worksheet and rename it at the same time
without knowing what excel named the new worksheet?

Thanks for any help.
Mike