Re: $$Excel-Macros$$ Index of sheets

Yes Correct MS Exl Learner, We need to press F2 in case of increase/decrease sheet. Aside to Lalit : We have create a name range as SheetsName and using it in formula. On Thu, Jan 10, 2013 at 12:41 PM, Ms-Exl-Learner wrote: > @ Noorain, > > But Change in Worksheet Name or addition of sheets

Re: $$Excel-Macros$$ Index of sheets

@ Noorain, But Change in Worksheet Name or addition of sheets are not automatically getting added in your solution, for which the user needs to press F2 in the formula cell or close the workbook and re-open it for getting it reflected. Slight enhancement has been done Your A2 cell formula *

Re: $$Excel-Macros$$ Index of sheets

Hi Noorain, Could you please explain the function u used *Get.workbook* * * and i think it is a UDF isn't it. Regards, Lalit Mohan On Thursday, 10 January 2013 12:12:14 UTC+5:30, NOORAIN ANSARI wrote: > > Dear Hari, > > See attached file by using only Excel Formula. > > =REPLACE(Get.workboo

Re: $$Excel-Macros$$ Index of sheets

Not possible without the help of Excel VBA or Third Party Addins. On 10-01-2013 10:57 AM, Hari wrote: Thanks for your help. but is there any formulae to get the same answers. Thanks, Harish On 10 January 2013 10:11, The Viper > wrote: Perhaps! He requires the

Re: $$Excel-Macros$$ Index of sheets

Thanks for your help. I got the answer for the same through below mail which i was looking for. Thanks, Harish On 9 January 2013 17:59, Paul Schreiner wrote: > What is it that you're looking for? > Are you writing VBA code and want to find out how many sheets are in a > workbook? > Are you tryi

Re: $$Excel-Macros$$ Index of sheets

Thanks for your help. but is there any formulae to get the same answers. Thanks, Harish On 10 January 2013 10:11, The Viper wrote: > Perhaps! He requires the list of available worksheet names from active > workbook > > Sub SheetIndex() > Dim i As Integer > For i = 1 To ActiveWorkbook.Sheets.Cou

Re: $$Excel-Macros$$ Index of sheets

What is it that you're looking for? Are you writing VBA code and want to find out how many sheets are in a workbook? Are you trying to use the Sheets() collection to get something to do with the sheets? The Sheets() collection is an array of sheets. The "index" of the Sheets() collection is the s

Re: $$Excel-Macros$$ Index of sheets

Dear Hari, Can you share your workbook? On Wed, Jan 9, 2013 at 5:27 PM, Hari wrote: > > Dear excel gurus, > > Please let me know how to get the index of sheets in a given excel > workbook. > > Thanks, > Harish > > -- > Yours, > > Hari. > > -- > Join official Facebook page of this forum @ >