This will work only on a workbook that has been opened from the hard disk
(in other words, the workbook must have been saved at least one time any
time in the past)...

=TRIM(RIGHT(SUBSTITUTE(CELL("filename",A1),"]",REPT(" ",99)),99))

--
Rick (MVP - Excel)


"Dale" wrote in message
...
Hi

Any ideas how I can get a cell in excel 2007 to automatically insert
whatever the tab name is?

Thanks

Dale