D D Fullman Mar 4, 2004 #1 I need a function which will allow a cell to look up the name of the tab (ie on the same sheet). Any ideas?
I need a function which will allow a cell to look up the name of the tab (ie on the same sheet). Any ideas?
B Bob Phillips Mar 4, 2004 #3 =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
