ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/226687-tabs.html)

Dale[_5_]

Tabs

Hi

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

Thanks

Dale

Rick Rothstein

Tabs

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

Dale[_5_]

Tabs

Thanks that's just the ticket

"Rick Rothstein" wrote in message
...
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

All times are GMT +1. The time now is 01:08 PM.