=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,
LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
Will get you the name of the active sheet. Anyone help offsetting the sheets (obviously placing "worksheet name!" infront of a1 will work, but it's manual)?
Could put this on each sheet and do some if statements on your main page.
Incidentally, the file needs to be saved for this to work.
Cheers,
Nate
This message was edited by NateO on 2002-02-22 16:19