cell A1=worksheet name

[TerryAnnThomas]

How do I make cell A1 show the name of the worksheet? Or
vice-versa....Can I make the worksheet tab show what ever text I put in
cell A1?
Thanks for looking, I appreciate any help!!

 

[TerryAnnThomas]

Try in any cell:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
(workbook must be saved first)
--
Max
Singapore

I was searching while hoping for a reply and I found the answer.
This is an awesome site, and I thank everyone involved from the host to
the users. I hope I can help someone sometime.

 

[Desert Piranha]

How do I make cell A1 show the name of the worksheet? Or
vice-versa....Can I make the worksheet tab show what ever text I put in
cell A1?
Thanks for looking, I appreciate any help!!

HiTerry,

If your interested in VBA, to name the worksheet tab, for whatever is
put into A1, this is one way, for one sheet. Can be made for all sheets
if you need.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ExitSub
If Not Application.Intersect(Me.Range("A1"), _
Target) Is Nothing Then _
Me.Name = Me.Range("A1").Value
ExitSub:
End Sub

 

[TerryAnnThomas]

Dave,

Thanks for your help, this is much better. I am very fasinated wit
VBA. However I find I require a lot of notes/cheat sheets with VBA a
I have a bad memory. At least I remember the capabilities of excel an
then I know how to use my notes or how to find -excel angels -lik
yourself. I Hope I can return the favor for someone even les
knowledgable than myself (I know there is _someone__ou
there!)

Seriously Dave, I appreciate your help!
Terr

 

[Desert Piranha]

Dave,

Thanks for your help, this is much better. I am very fasinated with
VBA. However I find I require a lot of notes/cheat sheets with VBA as
I have a bad memory. At least I remember the capabilities of excel and
then I know how to use my notes or how to find -excel angels -like
yourself. I Hope I can return the favor for someone even less
knowledgable than myself (I know there is _someone__out
there!)

Seriously Dave, I appreciate your help!
Terry

Hi Terry,
I'm sure you excel in other catagorys. (no pun intended)
Glad to be able to help.