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

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" wrote in
message ...
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

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


"Trevor Shuttleworth" wrote:

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" wrote in
message ...
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

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


"Janet Panighetti" wrote in
message ...
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


"Trevor Shuttleworth" wrote:

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" wrote in
message ...
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