Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet names 2
Do the worsksheets have a fixed identifier in addition to it's worksheet
name. ie/ is the first worksheet always 1 etc. If so, how can you identify the worksheet in this way. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet names 2
The worksheet has an index number, which start at 1 for the first sheet, 2
for the second, and changes if you move the sheets. But better yet, they have a codename, which you can change in the VBIDE, and which doesn't change as sheets move, or as a user renames the Excel name. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... Do the worsksheets have a fixed identifier in addition to it's worksheet name. ie/ is the first worksheet always 1 etc. If so, how can you identify the worksheet in this way. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet names 2
How do you include the index number in a formula, if you wanted to link to a
cell in worksheet one for example. VBIDE is new to me. Is there anywhere I can go for more information in this. "Bob Phillips" wrote: The worksheet has an index number, which start at 1 for the first sheet, 2 for the second, and changes if you move the sheets. But better yet, they have a codename, which you can change in the VBIDE, and which doesn't change as sheets move, or as a user renames the Excel name. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... Do the worsksheets have a fixed identifier in addition to it's worksheet name. ie/ is the first worksheet always 1 etc. If so, how can you identify the worksheet in this way. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet names 2
Phil,
We are talking VBA here, I don't know if you realised this? The VBIDE is accessed via Alt-F11, where you get access to VBA, macros, et al. When in the VBIDE, you have a explorer that shows all objects (worksheets, code modules, etc.) in that project (workbook). You also have a properties window, where you can change the codename. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... How do you include the index number in a formula, if you wanted to link to a cell in worksheet one for example. VBIDE is new to me. Is there anywhere I can go for more information in this. "Bob Phillips" wrote: The worksheet has an index number, which start at 1 for the first sheet, 2 for the second, and changes if you move the sheets. But better yet, they have a codename, which you can change in the VBIDE, and which doesn't change as sheets move, or as a user renames the Excel name. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... Do the worsksheets have a fixed identifier in addition to it's worksheet name. ie/ is the first worksheet always 1 etc. If so, how can you identify the worksheet in this way. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet names 2
Thanks
How do I identify the index number (which changes as you move the sheets) to use it in a formula "Bob Phillips" wrote: Phil, We are talking VBA here, I don't know if you realised this? The VBIDE is accessed via Alt-F11, where you get access to VBA, macros, et al. When in the VBIDE, you have a explorer that shows all objects (worksheets, code modules, etc.) in that project (workbook). You also have a properties window, where you can change the codename. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... How do you include the index number in a formula, if you wanted to link to a cell in worksheet one for example. VBIDE is new to me. Is there anywhere I can go for more information in this. "Bob Phillips" wrote: The worksheet has an index number, which start at 1 for the first sheet, 2 for the second, and changes if you move the sheets. But better yet, they have a codename, which you can change in the VBIDE, and which doesn't change as sheets move, or as a user renames the Excel name. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... Do the worsksheets have a fixed identifier in addition to it's worksheet name. ie/ is the first worksheet always 1 etc. If so, how can you identify the worksheet in this way. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet names 2
The first sheet is always 1. If you have the name then you can use
Worksheets("mySheet").Index -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... Thanks How do I identify the index number (which changes as you move the sheets) to use it in a formula "Bob Phillips" wrote: Phil, We are talking VBA here, I don't know if you realised this? The VBIDE is accessed via Alt-F11, where you get access to VBA, macros, et al. When in the VBIDE, you have a explorer that shows all objects (worksheets, code modules, etc.) in that project (workbook). You also have a properties window, where you can change the codename. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... How do you include the index number in a formula, if you wanted to link to a cell in worksheet one for example. VBIDE is new to me. Is there anywhere I can go for more information in this. "Bob Phillips" wrote: The worksheet has an index number, which start at 1 for the first sheet, 2 for the second, and changes if you move the sheets. But better yet, they have a codename, which you can change in the VBIDE, and which doesn't change as sheets move, or as a user renames the Excel name. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phil" wrote in message ... Do the worsksheets have a fixed identifier in addition to it's worksheet name. ie/ is the first worksheet always 1 etc. If so, how can you identify the worksheet in this way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
In Excel, how do I change worksheet headers (A,B) to names (Box)? | New Users to Excel | |||
Lookups using worksheet names | Excel Discussion (Misc queries) | |||
Dynamic Worksheet Names | Links and Linking in Excel |