Next lng
>
> End Sub
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Sam Mathai Chacko
> Sent: 14 November 2011 07:00
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Listing name of workshe
ember 2011 07:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
There is a sheet by the name ..Sorter..
In the first column of the sheet you can get the list of all sheets in
the workbook by clicking on the first button. in the next co
thai Chacko
> Sent: 13 November 2011 23:02
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
>
> Would it be OK if you had to click 3 buttons for that?
>
> Macro used
>
> Option Explicit
>
> Sub GetListO
ent: 13 November 2011 23:02
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
Would it be OK if you had to click 3 buttons for that?
Macro used
Option Explicit
Sub GetListOfSheets()
Dim lng As Long
For lng = 1 To Sheets.Count
gt;
[mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On
Behalf Of Aindril De
Sent: 13 November 2011 14:04
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
Pl chk this
xcel-macros@googlegroups.com] On
Behalf Of Aindril De
Sent: 13 November 2011 14:04
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
Pl chk this,
http://support.microsoft.com/kb/812386
Cheers,
Andy
On Sun, Nov 13, 2011 at 1:36 PM, Amit Des
Pl chk this,
http://support.microsoft.com/kb/812386
Cheers,
Andy
On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU)
wrote:
> Dear Master,
>
> ** **
>
> I have an excel file with sheet names ranging from A to V. However I want
> to change its sequence post changing its name.
>
> ** **
>
Dear Master,
I have an excel file with sheet names ranging from A to V. However I want to
change its sequence post changing its name.
Do we have any shortcut?
Regards,
Amit Desai
AM - MIS Corporate
Meru Cabs Company Pvt.Ltd
Mumbai
Mob:9867232534
[cid:image001.gif@01CCA209.4B1EB210]
_