cell A1=worksheet name

  • Thread starter Thread starter TerryAnnThomas
  • Start date Start date
T

TerryAnnThomas

:confused: 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!! ;)
 
Try in any cell:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
(workbook must be saved first)
--
Max
Singapore

:eek: 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.:)
 
TerryAnnThomas said:
:confused: 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!! ;)
Click to expand...
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
 
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 :rolleyes: there is _someone__ou
there!)

Seriously Dave, I appreciate your help!
Terr
 
TerryAnnThomas said:
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 :rolleyes: there is _someone__out
there!)

Seriously Dave, I appreciate your help!
Terry
Click to expand...
Hi Terry,
I'm sure you excel in other catagorys. (no pun intended) :)
Glad to be able to help.
 
Back
Top