Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Sheet
Is there anyway to automatically name a sheet with a cells content? -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571408 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Sheet
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target Me.Name = .Value End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mehare" wrote in message ... Is there anyway to automatically name a sheet with a cells content? -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571408 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Sheet
Thanks for the help but I've never used code in Excel. I've pasted it in, the left hand drop down menu says "worksheet" and the right hand "change". Is this correct? The information I want as the name of the sheet is in cell b1. Do I have to change anything in the code to make this happen? Thanks again -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571408 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Sheet
Yes, change
Const WS_RANGE As String = "A1" to -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mehare" wrote in message ... Thanks for the help but I've never used code in Excel. I've pasted it in, the left hand drop down menu says "worksheet" and the right hand "change". Is this correct? The information I want as the name of the sheet is in cell b1. Do I have to change anything in the code to make this happen? Thanks again -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571408 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Sheet
Yes, change
Const WS_RANGE As String = "A1" to Const WS_RANGE As String = "B1" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mehare" wrote in message ... Thanks for the help but I've never used code in Excel. I've pasted it in, the left hand drop down menu says "worksheet" and the right hand "change". Is this correct? The information I want as the name of the sheet is in cell b1. Do I have to change anything in the code to make this happen? Thanks again -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571408 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making for adding and naming a new sheet | Excel Discussion (Misc queries) | |||
Need to look up value in another Sheet based on criteria in first sheet. | Excel Worksheet Functions | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |