Is it possible to add a worksheet to the active workbook with a preset name? Sound confusing <img src=/S/confused.gif border=0 alt=confused width=15 height=20>, that's because I suck at explaining things.
Basically, I am looking for a way to add a worksheet and name it "Average" (without quotes). I know how to do this if I know the name of the sheet that was just added. For example, if I open a new workbook with 3 worksheets (sheet1, sheet2, and sheet3) I know how to change the name of the new worksheet (sheet4) to Average. But what if I don't know how many worksheets are in the workbook and/or don't know what their names are.
Is it possible to do something like Worksheet("Average").Add? <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>