Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nameing a worksheet
Is it possible to name a sheet based on 2 cell values with either a formula
or VB? Example A1=4/20/09 B2=Help worksheet name is Help 4/20/09 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
nameing a worksheet
"/" is not an accepted character for sheet names. So you need to change that
to something else. I have used Format() function to have the date in a different format. Try the below code from Immediate window and see. Launch VBE using Alt+F11 and Ctrl+G to view the immediate window A1=4/20/09 B2=Help Activesheet.name = Range("A2") & " " & Format(Range("A1"),"mm-dd-yyyy") If this post helps click Yes --------------- Jacob Skaria "Lost" wrote: Is it possible to name a sheet based on 2 cell values with either a formula or VB? Example A1=4/20/09 B2=Help worksheet name is Help 4/20/09 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
nameing a worksheet
You can also refer the sheet using the Sheet name or the Sheet index number.
Sheets("Sheet1").Name = "<New Name" Sheets(1).Name = "<New Name" If this post helps click Yes --------------- Jacob Skaria "Lost" wrote: Is it possible to name a sheet based on 2 cell values with either a formula or VB? Example A1=4/20/09 B2=Help worksheet name is Help 4/20/09 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nameing cells in workbook | Excel Discussion (Misc queries) | |||
column nameing | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
In nameing a sheet in Excel it puts a .xls] in front why? | Excel Discussion (Misc queries) |