Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Field value defines worksheet name
Hi,
I want to make a worksheet name in Excel 2003 equal the value of a field in the same worksheet. Is this possible? I see a few ways of doing it the other way round. The field is a date format and I need this to be the name of the worksheet. Thanks, Gary. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Field value defines worksheet name
One solution, given a date in cell A1, you cannot name a sheet with the
following characters \ / ? * [ ] by using the date and format you can eliminate the default / used in dates. With ActiveSheet.Range("A1") If IsDate(.Range("A1")) Then ActiveSheet.Name = Format(.Range("A1"), "dd-mm-yyyy") End With -- Regards, Nigel "Gary" wrote in message ... Hi, I want to make a worksheet name in Excel 2003 equal the value of a field in the same worksheet. Is this possible? I see a few ways of doing it the other way round. The field is a date format and I need this to be the name of the worksheet. Thanks, Gary. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Field value defines worksheet name
On 28 Apr, 09:57, "Nigel" wrote:
One solution, given a date in cell A1, you cannot name a sheet with the following characters \ / ? * [ ] by using the date and format you can eliminate the default / used in dates. With ActiveSheet.Range("A1") * *If IsDate(.Range("A1")) Then *ActiveSheet.Name = Format(.Range("A1"), "dd-mm-yyyy") End With -- Regards, Nigel "Gary" wrote in message ... Hi, I want to make a worksheet name in Excel 2003 equal the value of a field in the same worksheet. Is this possible? I see a few ways of doing it the other way round. The field is a date format and I need this to be the name of the worksheet. Thanks, Gary.- Hide quoted text - - Show quoted text - Thanks for this. How would this be programmed into Excel? I know how to attach code to buttons, but how would this work? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering out records from one worksheet by comparing a field in it with a field in another worksheet | New Users to Excel | |||
user defines macro to run | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Can Step through but when run defines variable wrong | Excel Programming | |||
What defines number or text | New Users to Excel |