>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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 que
ailable apart from the above two.If
> so then would request you to please help me and the group with that.
>
> It will be of great help for us.
>
>
> Thanks & Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> Date: Mon, 16 Jul 2012 15:21:11 +0530
> Subject: Re
Dear Santosh,
I think it is not possible to get all the sheets name by using only formula.
Regards,
Lalit Mohan
On Mon, Jul 16, 2012 at 3:21 PM, NOORAIN ANSARI
wrote:
> Dear Santosh,
>
> Please create a name range with below formula..
>
> =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),""
Dear Santosh,
Please create a name range with below formula..
*=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")*
and use below formula to extract sheet name in column A.
*
=IF(ROWS($A$2:A2<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
*
See attached sheet for
hi santosh,
PFA below vbacode to findout the sheetsname.
Sub sheets_nm()
Dim sh As Worksheet
Dim i As Integer, k As Integer
Set sh = ThisWorkbook.Sheets("sheet1")
For i = 1 To Sheets.Count
k = Range("a5").End(xlUp).Row + 1
sh.Cells(k, 1) = Sheets(i).Name
Next
End Sub
Regards,
excelvb
Hi Group,
I want the list of all the sheet names available or to created in sheet1
automatically via formula of a workbook *without a macro.*
Thanks & Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
