Tabs

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

Hi

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

Thanks

Dale
 
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))
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Customize Ribbon In Word 2007 1
spread sheet protection over several tabs 7
Excel 2007 not showing tabs 6
Grayed out Tab in Excel 1
Automatically copy the file name to the worksheet tab 3
Dragging/Copying Formulas in Excel 2007 3
Inserting Rows with tabs grouped 2
Calculating inserted rows or colums from another sheet 1

Back
Top