How do I create a cell reference to return name of the tab?

B

Biff

Just to add.....

The file must already exist. It must have been saved and given a name.

Biff

Gary''s Student said:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary's Student


pameluh said:
For example... the tab name is Apples. I want cell A1 to say Apples
Click to expand...
Click to expand...
 
T

Tom Ogilvy

The file must already exist. It must have been saved and given a name.

Another way to say this is:

The file must have been previously saved for this to work.

--
Regards,
Tom Ogilvy


Biff said:
Just to add.....

The file must already exist. It must have been saved and given a name.

Biff

Gary''s Student said:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary's Student


pameluh said:
For example... the tab name is Apples. I want cell A1 to say Apples
Click to expand...
Click to expand...
Click to expand...
 

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

Pasting cell contents into a macro 1
Displaying contents of Active Cell 4
Return Top Ranks For Certain Categories in Column 7
How to change format for an individual word in a cell 1
Counting consecutive strings of text 2
Retrieve Column Header for Specific Data in a Row 3
Precedents 3
Excel 2003 Conditional formatting challenge question 11

Top