Dear Harmeet Singh,
It s working thanks a lot
On Tue, Jun 1, 2010 at 4:08 PM, Harmeet Singh <harmeet.hew...@gmail.com>wrote:
> *Here you go....*
> *use mentioned code*
> *
> *
> *Sub ren()*
> *
> *
> *mo = InputBox("Enter Month number.")*
> *
> *
> *For i = 1 To Application.Worksheets.Count*
> *
> *
> * Sheets(i).Name = Left(Sheets(i).Name, 3) & mo & Right(Sheets(i).Name,
> 3)*
> *Next i*
> *
> *
> *End Sub*
>
>
>
> Warm Regards,
>
> Harmeet Singh
>
> http://www.facebook.com/libraharry
>
>
>
> On Tue, Jun 1, 2010 at 3:07 PM, Venkatesan c <venkat1....@gmail.com>wrote:
>
>> 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
