How to get current worksheet name to display in a cell?

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

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