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
------------------------------------------------------------------------
TerryAnnThomas's Profile: http://www.excelforum.com/member.php...o&userid=31837
View this thread: http://www.excelforum.com/showthread...hreadid=515581

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


--
TerryAnnThomas
------------------------------------------------------------------------
TerryAnnThomas's Profile: http://www.excelforum.com/member.php...o&userid=31837
View this thread: http://www.excelforum.com/showthread...hreadid=515581

TerryAnnThomas Wrote:
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


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=515581

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


--
TerryAnnThomas
------------------------------------------------------------------------
TerryAnnThomas's Profile: http://www.excelforum.com/member.php...o&userid=31837
View this thread: http://www.excelforum.com/showthread...hreadid=515581

TerryAnnThomas Wrote:
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.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=515581