Use this macro to Rename the sheet.
Sub Renamesheet()
Dim shtName As String
For Each sht In ThisWorkbook.Sheets
shtName = sht.Name
shtName = Left(shtName, 2) & Replace(shtName, "05", "06", 3)
sht.Name = shtName
Next
End Sub
Regards,
Jitendra Kr. Verma
________________________________
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Venkatesan c
Sent: Tuesday, June 01, 2010 3:07 PM
To: Google
Subject: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired
Dear Group,
I have attached here file for help required.
I am having 31 sheets the sheet names contains like 31.05.10,30.05.10,etc .
want to change the sheet names Like 31.06.10,30.06.10,etc by using macros
automatically
is there anything macros please assist me
Best Regards,
Venkat
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
