Cell References

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Gord:

Thanks! This also helped me with the same issue!

jb

Gord Dibben said:
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?
Click to expand...
Click to expand...
 
Back
Top