Help with sheet renaming macro please

[kbriaz]

Please Login or Register  to view this content.

Hi,

Excel noob here, can someone please help with above code ?

I want to re-name Sheet1 to Test1 - Todays date

It seems to debug.

Many thanks for your help - ta

[ragavan.sridar1]

Try this code.

Please Login or Register  to view this content.

[kbriaz]

Try this code.

Please Login or Register  to view this content.

Thank you very much. Great help. Ta