Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name a worksheet using a cell
I want to name the tab in my worksheet based on what cell A1 says. I this possible -- ineedhelp ----------------------------------------------------------------------- ineedhelp2's Profile: http://www.excelforum.com/member.php...fo&userid=2629 View this thread: http://www.excelforum.com/showthread.php?threadid=40159 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name a worksheet using a cell
activesheet.name= range("A1").Value
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name a worksheet using a cell
Below is some code that you might find as being a bit more versatile.
What it will do is take cell contents from column 1 and create a new sheet with that name .. in the correct order! _!_!!_!_!_!__!_!_!_!_!_!_!_ Public Sub CreateSheetNamesFromList() Dim Nayme As String Dim K As Byte K = 1 Range("a1").Select 'this is the first cell in List Do Until ActiveCell.Value = "" 'Loop until a blank cell is encountered Nayme = ActiveCell.Value Sheets.Add ActiveSheet.Name = Nayme Sheets(Nayme).Move After:=Sheets(K + 1) Sheets("List").Select ActiveCell.Offset(1, 0).Select K = K + 1 Loop End Sub !_!_!!_!_!_!_!_!_!_!_ -- Chris Togeretz Ontario, Canada "ineedhelp2" wrote: I want to name the tab in my worksheet based on what cell A1 says. Is this possible? -- ineedhelp2 ------------------------------------------------------------------------ ineedhelp2's Profile: http://www.excelforum.com/member.php...o&userid=26298 View this thread: http://www.excelforum.com/showthread...hreadid=401594 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I click on a cell on one worksheet and make it take me to another worksheet | New Users to Excel | |||
Linking Tab/worksheet names to a worksheet cell | Excel Discussion (Misc queries) | |||
copy cell from one worksheet to another worksheet in exel | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
selecting cell range in other worksheet without switching to worksheet | Excel Programming |