Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to insert a new workbook that is named from a cell
value plus a contstant. I have done this with inserting worksheets like this: Sheets.Add.Name = Range("B2").Value What I want is something like Workbooks.Add.Name = Range("B2") & "constant".Value Is there a different syntax for workbooks and worksheets? If so I would like to see both. I have a tool that I want to keep clean so when the user is finished entering data I am taking that information and storing it in a new workbook named from a value in the tool and then inserting 2 worksheets named for the value + contstant. The constant is obviously unique for each page. Thanks Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming sheets after a range | Excel Discussion (Misc queries) | |||
Naming sheets from a cell value | Excel Discussion (Misc queries) | |||
Date calculation across workbooks / Workbook naming question. | Excel Discussion (Misc queries) | |||
VBA Help naming sheets | Excel Discussion (Misc queries) | |||
Naming multiple sheets | Excel Discussion (Misc queries) |