Creating a function to add a new worksheet
I have created a vba procedure to add a new worksheet.
Private Sub AddSheet()
ActiveWorkbook.Worksheet.add
End sub
I would like to add more functionality to this procedure such as, giving a name to the new worksheet as soon as it is created. Also I would like to name the sheet using the current month and year e.g. "July 2004".
|
