Thank you all!
You help me a lot!
and sorry if I have not be clear, I need to practice my english...
bye
2011/11/8 Sam Mathai Chacko
> In Noorain's solution, the name of the defined name formula would be *
> SheetNames*
>
> Also, you can find here a UDF through VBA as well
>
>
> http://www.e
In Noorain's solution, the name of the defined name formula would be *
SheetNames*
Also, you can find here a UDF through VBA as well
http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/
Regards,
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 11:40 PM, NOORAIN ANSARI wrote:
In Excel Version
Write formula in refers To Under Formula ->Define Name
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
Paste it in Cell A1
=IF(ROWS($A$2:A2)<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
--
Thanks & regards,
Noorain Ansari
*http:/
Dear Chamili,
SAM's statement is right, your question is not more clear.
if you want only Sheet's Name you can try..
Sub Summary_sheet()
Dim i, sh As Integer
Sheet1.Cells(1, "A").Value = "Summary"
sh = Sheets.Count
For i = 2 To sh
Sheet1.Cells(i, "A").Value = Sheets(i).Name
Next i
End Sub
--
T
Check this link and let me know this was helpful.
"http://sourcedaddy.com/ms-excel/create-list-worksheet-names.html";
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: Chamili Coelho da Costa
Sender: excel-macros@googlegroups.com
Date: Tue, 8 Nov 2011 12:56:20
To:
Reply-To:
Your question is not clear. The sample you attached just shows the name of
the sheets listed, except the first sheet. What does that indicate? Can you
be a little more descriptive of what you require.
Regards,
Sam
On Tue, Nov 8, 2011 at 8:26 PM, Chamili Coelho da Costa
wrote:
> Hi!
>
> How can I
