reference current worksheet name (tab name) in a formula

[Janet Panighetti]

How may I reference the current worksheet name (the name on the tab) in a
formula on that worksheet.

In other words, I want to compare the string in a cell to the name of the
current worksheet. If it matches then I want to raise an error.

Thanks in advance!

Janet

 

[Trevor Shuttleworth]

Janet

courtesy of:

www.ozgrid.com http://www.ozgrid.com/VBA/return-sheet-name.htm
Return an Excel Worksheet Name to a Cell

In Excel it is possible to use the CELL function/formula and the MID and
FIND to return the name of an Excel Worksheet in a Workbook. The formula
below shows us how;

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Where A1 is any non error cell on the Worksheet. If you want the full path
of the Excel Workbook, simply use;

=CELL("filename",A1)

It is important to note that the above formulas will only work in a Workbook
that has been saved.

Search Google for: cell worksheet name excel for other references

Regards

Trevor

 

[Janet Panighetti]

Very cool, Trevor!

Since all the worksheet names are a 6 digit number, I modified your
suggestion to the following:

=RIGHT(CELL("FILENAME",A1),6)

and it works GREAT!!!!!!!!!!!!!! I'll just have to remember to save the
workbook to get the new tabnames.

Thanks!!!!!!!!!!

Janet

Janet

courtesy of:

www.ozgrid.com http://www.ozgrid.com/VBA/return-sheet-name.htm
Return an Excel Worksheet Name to a Cell

In Excel it is possible to use the CELL function/formula and the MID and
FIND to return the name of an Excel Worksheet in a Workbook. The formula
below shows us how;

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Where A1 is any non error cell on the Worksheet. If you want the full path
of the Excel Workbook, simply use;

=CELL("filename",A1)

It is important to note that the above formulas will only work in a Workbook
that has been saved.

Search Google for: cell worksheet name excel for other references

Regards

Trevor

How may I reference the current worksheet name (the name on the tab) in a
formula on that worksheet.

In other words, I want to compare the string in a cell to the name of the
current worksheet. If it matches then I want to raise an error.

Thanks in advance!

Janet

 

[Trevor Shuttleworth]

Janet

you're very welcome. Thanks for the feedback. As I said, credit to OZGRID
for this solution, although you'll find it in lots of other places.

Regards

Trevor

Very cool, Trevor!

Since all the worksheet names are a 6 digit number, I modified your
suggestion to the following:

=RIGHT(CELL("FILENAME",A1),6)

and it works GREAT!!!!!!!!!!!!!! I'll just have to remember to save the
workbook to get the new tabnames.

Thanks!!!!!!!!!!

Janet

Janet

courtesy of:

www.ozgrid.com http://www.ozgrid.com/VBA/return-sheet-name.htm
Return an Excel Worksheet Name to a Cell

In Excel it is possible to use the CELL function/formula and the MID and
FIND to return the name of an Excel Worksheet in a Workbook. The formula
below shows us how;

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Where A1 is any non error cell on the Worksheet. If you want the full
path
of the Excel Workbook, simply use;

=CELL("filename",A1)

It is important to note that the above formulas will only work in a
Workbook
that has been saved.

Search Google for: cell worksheet name excel for other references

Regards

Trevor

How may I reference the current worksheet name (the name on the tab) in
a
formula on that worksheet.

In other words, I want to compare the string in a cell to the name of
the
current worksheet. If it matches then I want to raise an error.

Thanks in advance!

Janet