Naming Sheets with the Date.

[Baziwan]

Hi,

I have a macro that automatically adds a sheet to a workbook, it then renames it with the Date using this code:-

ActiveSheet.Name = Format(Date, "DD-MM-YYYY")  

The problem I have is that I can only do this once a day otherwise I get an error because a worksheet already exists with the Date. Is there a way I can do this so that if a sheet with the same date already exists it will rename the new one "DD-MM-YYYY 2". So on and So forth.

Thanks in Advance

[Marcol]

Try this

Please Login or Register  to view this content.

Hope this helps

[contaminated]

Hi
Try this macro

Please Login or Register  to view this content.

[Bob Phillips]

Try

Please Login or Register  to view this content.

[contaminated]

Bob Phillips
I understand what "On Error GoTo Next" statement
But how to understand "GoTo 0" and why to use two error handling option in one sub????

[Baziwan]

Thanks alot for the swift responce Marcol!
That works Fine.

[Marcol]

Contaminated

Please Login or Register  to view this content.

Cancels the error handler and prevents unwanted instruction being carried over to further code

[contaminated]

Thanks Marcol
I just used "On Error GoTo 0" statement in previous code
Great explanation... Better than in books...