Re: List of worksheets

Tech-Archive recommends: Fix windows errors by optimizing your registry

Cool!


Gord

On Wed, 9 Jul 2008 14:10:07 -0500, "Héctor Miguel"
<NOhemiordiSPAM@xxxxxxxxxxxxxx> wrote:

hi, Igor !

I'm wondering if it's possible to make a list of all worksheets using Excel functions only.
Assuming the first work*** is "TheList" I want to make, in that workbook
a list of all worksheets right from that worksheet using functions only?
Is it possible?

1) be sure "TheList" *** is the first (index) in the workbook

2) put a title in A1 (i.e. Sheets in this workbook)

3) define/create a name (menu: insert / names / define...)
name: n_Sheets
formula: =get.workbook(1+0*now())

4) get the list with the following formula:
[A2] =choose(1+(row()>counta(n_sheets)),mid(index(n_sheets,row()),search("]",index(n_sheets,1))+1,31),"")

5) copy/drag/... A2-formula n_rows down (as needed)

hth,
hector.


.

Quantcast