How do I retrieve the TAB name from within a spreadsheet to insert into a cell?
B Bob Harike Feb 2, 2005 #1 How do I retrieve the TAB name from within a spreadsheet to insert into a cell?
P Peo Sjoblom Feb 2, 2005 #2 Workbook needs to be saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) Regards, Peo Sjoblom Bob Harike said: How do I retrieve the TAB name from within a spreadsheet to insert into a Click to expand... cell?
Workbook needs to be saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) Regards, Peo Sjoblom Bob Harike said: How do I retrieve the TAB name from within a spreadsheet to insert into a Click to expand... cell?
B Bob Harike Feb 2, 2005 #3 Just right .. Thanks. Peo Sjoblom said: Workbook needs to be saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) Regards, Peo Sjoblom Bob Harike said: How do I retrieve the TAB name from within a spreadsheet to insert into a Click to expand... cell? Click to expand...
Just right .. Thanks. Peo Sjoblom said: Workbook needs to be saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) Regards, Peo Sjoblom Bob Harike said: How do I retrieve the TAB name from within a spreadsheet to insert into a Click to expand... cell? Click to expand...
