Cell References

[a]

How do I make a cell equal to the name of the worksheet that I am currently
using without typing the name in each worksheet?

 

[Gord Dibben]

One method

Right-click on a sheet tab and "Select all sheets"

In any cell on the active sheet enter this formula.

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Ungroup the sheets.

Note: the A1 reference is irrelevant as far as the address, but some cell
reference must be used in the formula.

See Bob Phillips' site for more info.

NOTE: the workbook must have been saved otherwise you get an error.

Another method would be to use event code to show the sheet name in a cell
whenever the sheet is activated.


Gord Dibben MS Excel MVP

 

[JudithJubilee]

Hi

Try this link

http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Gord Dibben]

Which is the link I meant to provide in my post<g>

Thanks for including it.

Gord

 

[Nebulous]

Gord:

Thanks! This also helped me with the same issue!

jb

One method

Right-click on a sheet tab and "Select all sheets"

In any cell on the active sheet enter this formula.

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Ungroup the sheets.

Note: the A1 reference is irrelevant as far as the address, but some cell
reference must be used in the formula.

See Bob Phillips' site for more info.

NOTE: the workbook must have been saved otherwise you get an error.

Another method would be to use event code to show the sheet name in a cell
whenever the sheet is activated.


Gord Dibben MS Excel MVP

How do I make a cell equal to the name of the worksheet that I am currently
using without typing the name in each worksheet?