Replace sheetname

[excelthong]

Hi

if i have 60+ sheets which are in format 080627NAME, may i know how can i replace the date to 080628 using macro?

i thought its simple but my macro return error

thank you

 

[dafan]

Try this:

Dim ws As Worksheet

For Each ws In Worksheets

 ws.Name= Replace( ws.Name, "080627", "080628")

Next

 

[excelthong]

thanks lot!