I need to get the current worksheet name into a cell.
Each worksheet is a number (eg 1,2,3,4 etc)
Two reasons:
1. So ppl can see which worksheet they are looking on
2. So I can use a lookup to get a value from a master sheet into the right
worksheet.
Can't find anything!!

Try

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563953

xfixiate wrote:
I need to get the current worksheet name into a cell.
Each worksheet is a number (eg 1,2,3,4 etc)
Two reasons:
1. So ppl can see which worksheet they are looking on
2. So I can use a lookup to get a value from a master sheet into the right
worksheet.
Can't find anything!!

Hi,

Maybe you can use something like this:

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

Regards,
Bondi