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