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

X

xfixiate

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!!
 
V

VBA Noob

Try

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

VBA Noob
 
B

Bondi

xfixiate said:
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!!
Click to expand...

Hi,

Maybe you can use something like this:

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

Regards,
Bondi
 
Top