Macro to rename a sheet using a date.

Hi there. I'm using a VBA macro that copy some information from a sheet. Then it creates another sheet and rename it with a fixed name lets say "blabla". The thing is that if the workbook already has a sheet with this name the macro stoppes. So what is that this macro checks if a sheet named as "blabla" already exist and if it does then renames the new sheet as "blablatoday". If the use of date is not possible I would accept something like "blabla_1" "blabla_2" and so on.

Thanks a lot.

Augusto.

Here's a macro i generated created for this kind of sheetname renaming

This macro checks if a workbook exists.

Please Login or Register  to view this content.

And here is the portion of a code that changes the sheetname.

Please Login or Register  to view this content.

Then you could do something like...

Please Login or Register  to view this content.