bdsii
03-18-2010, 07:42 AM
I would like to add a new worksheet and want the name of the new worksheet to be the date and time. This will help if the macro is run repeatedly so that each time it is run, the worksheet name will be unique.
I tried the code below and it did not work. I change the type of NewName to String and that didn't help either.
Any ideas ?
Dim NewName As Integer
NewName.Value = CDbl(Now)
Worksheets.Add
ActiveSheet.Name = NewName
thanks !
I tried the code below and it did not work. I change the type of NewName to String and that didn't help either.
Any ideas ?
Dim NewName As Integer
NewName.Value = CDbl(Now)
Worksheets.Add
ActiveSheet.Name = NewName
thanks !