How do I create a cell reference to return name of the tab?
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" wrote in message
...
Just to add.....
The file must already exist. It must have been saved and given a name.
Biff
"Gary''s Student" wrote in
message ...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary's Student
"pameluh" wrote:
For example... the tab name is Apples. I want cell A1 to say Apples
|