Yes, I was trying to find a formula to name a sheet tab so that whatever I
type in A1 would name the tab. I even tried =A1 in the tab itself
(desperation).
Macros scare me, because I have not idea where to start unless I am
recording a macro.

"Alan" wrote:

The formula looks like an answer to a specific question, what the original
question was is hard to say. It's series of text fomulas doing something,
not sure what!
What are you trying to achieve? You mention naming tabs, if you mean sheet
tabs, you can only do that manually or with VB code, a formula can't do
that.
Post back explaining what you want to do, I'm sure you'll get answers,
Regards,
Alan.
"SharonJo" wrote in message
...
I saw a previous question for this, but I need help understanding the
formula.
I tried coping this formula, into A1, but--what do I need to change?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))