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)))

The workbook must be saved.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"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)))

Good one Jim!
Alan.
"Jim Cone" wrote in message
...
The workbook must be saved.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"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)))

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)))

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)))

One crude way to get you started, (do this in a new workbook),

Hit Alt and F11 to open the VB editor,
On the top toolbar hit 'Insert'
In the dropdown list hit 'Module', (not 'Class Module')
Copy and paste this into the empty window,

Sub NameSheet()
ActiveSheet.Name = ActiveSheet.Range("A1")
End Sub

Hit Alt and F11 together to close the VB editor, thats the Macro done.

Now type something into A1, click 'Tools' on the toolbar at the top, select
'Macro', to the left of the dropdown select 'Macros', in the box that
appears you'll see only one Macro called 'NameSheet'
Hit 'Run' and the sheet tab will change,

There are other way to do this with buttons, it can do it for you when you
open the sheet, or when you type something into A1, post back with what you
want it to do,

Regards,
Alan.
"SharonJo" wrote in message
...
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)))

Forgot to mention, when you get to the dialogue box with the Macros in it
and hit run, at the bottom is a button marked 'Options'
Click that and it asks what key you want as a shortcut, so if you enter 'z'
for instance, hitting Crtl and z together will run it for you without having
to use any toolbars etc,
Regards,
Alan.
"Alan" wrote in message
...
One crude way to get you started, (do this in a new workbook),

Hit Alt and F11 to open the VB editor,
On the top toolbar hit 'Insert'
In the dropdown list hit 'Module', (not 'Class Module')
Copy and paste this into the empty window,

Sub NameSheet()
ActiveSheet.Name = ActiveSheet.Range("A1")
End Sub

Hit Alt and F11 together to close the VB editor, thats the Macro done.

Now type something into A1, click 'Tools' on the toolbar at the top,
select 'Macro', to the left of the dropdown select 'Macros', in the box
that appears you'll see only one Macro called 'NameSheet'
Hit 'Run' and the sheet tab will change,

There are other way to do this with buttons, it can do it for you when you
open the sheet, or when you type something into A1, post back with what
you want it to do,

Regards,
Alan.
"SharonJo" wrote in message
...
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)))

WooHoo! Thank you, it works perfectly!
The only thing that I have not figured out is if I need to create this macro
in each of my workbooks or if there is some way to make it available in any
workbook!

"Alan" wrote:

Forgot to mention, when you get to the dialogue box with the Macros in it
and hit run, at the bottom is a button marked 'Options'
Click that and it asks what key you want as a shortcut, so if you enter 'z'
for instance, hitting Crtl and z together will run it for you without having
to use any toolbars etc,
Regards,
Alan.
"Alan" wrote in message
...
One crude way to get you started, (do this in a new workbook),

Hit Alt and F11 to open the VB editor,
On the top toolbar hit 'Insert'
In the dropdown list hit 'Module', (not 'Class Module')
Copy and paste this into the empty window,

Sub NameSheet()
ActiveSheet.Name = ActiveSheet.Range("A1")
End Sub

Hit Alt and F11 together to close the VB editor, thats the Macro done.

Now type something into A1, click 'Tools' on the toolbar at the top,
select 'Macro', to the left of the dropdown select 'Macros', in the box
that appears you'll see only one Macro called 'NameSheet'
Hit 'Run' and the sheet tab will change,

There are other way to do this with buttons, it can do it for you when you
open the sheet, or when you type something into A1, post back with what
you want it to do,

Regards,
Alan.
"SharonJo" wrote in message
...
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)))

That formula will not re-name a sheet tab.

All it does is place the sheet tab name into a cell.

If you stuck with your first question you would see a reply from Jim that sends
you to Ron de Bruin's site for where to place the code you posted earlier.

That was the correct code.


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 17:27:00 -0700, SharonJo
wrote:

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)))