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?

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

On Tue, 24 Jul 2007 08:58:03 -0700, a wrote:

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?

Hi

Try this link

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


--
Hope this helps


"a" wrote:

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?

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

Thanks for including it.

Gord

On Tue, 24 Jul 2007 09:32:05 -0700, JudithJubilee
wrote:

Hi

Try this link

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

Gord:

Thanks! This also helped me with the same issue!

jb

"Gord Dibben" wrote:

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

On Tue, 24 Jul 2007 08:58:03 -0700, a wrote:

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?