Tabs

D

Dale

Hi

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

Thanks

Dale
 
R

Rick Rothstein

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))
 
D

Dale

Thanks that's just the ticket


Rick Rothstein said:
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 said:
Hi

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

Thanks

Dale
Click to expand...
Click to expand...
 
Top