@ 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
*=IFERROR(INDEX(SheetsName,ROWS($A$1:A1)),"")*
Is changed to
*=IFERROR(MID(TODAY()&INDEX(SheetsName,ROWS($A$1:A1)),6,255),"")*
As usual needs to be dragged down....
On 10-01-2013 12:12 PM, NOORAIN ANSARI wrote:
Dear Hari,
See attached file by using only Excel Formula.
=REPLACE(Get.workbook(1),1,find("]",Get.workbook(1))," ") Create Name
range
=IFERROR(INDEX(SheetsName,ROWS($A$1:A1)),"") use as a formula
On Thu, Jan 10, 2013 at 10:58 AM, Hari <harisha.prabha...@gmail.com
<mailto:harisha.prabha...@gmail.com>> wrote:
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 <schreiner_p...@att.net
<mailto:schreiner_p...@att.net>> 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 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 specific sheet
of the Sheets array.
If the second sheet of the workbook is currently active, that
would be Sheets(2)
So, when you say "get the index of sheets", do you mean you
want to know what is the index number in the Sheets collection
for the currently active sheet?
Or are you not using VBA at all and need something else entirely?
Please elaborate on your requirement.
/Paul/
-----------------------------------------
/*“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*/-----------------------------------------
------------------------------------------------------------------------
*From:* Hari <harisha.prabha...@gmail.com
<mailto:harisha.prabha...@gmail.com>>
*To:* excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>
*Sent:* Wed, January 9, 2013 6:57:56 AM
*Subject:* $$Excel-Macros$$ Index of sheets
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may
not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the
Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to
excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
Visit this group at
http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may
not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the
Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to
excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
Visit this group at
http://groups.google.com/group/excel-macros?hl=en.
--
Yours,
Hari.....
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
With Regards,
Noorain Ansari
http:// <http://www.noorainansari.com>noorainansari.com
<http://www.noorainansari.com>
http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com
<http://www.excelvbaclinic.blogspot.com>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
