| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confusion with Names
See your other post.
mfq1975 wrote: When I go to the VBA IDE of a workbook, I see the Project Explorer, Properties Window, and the Code window. If I look at the Project Explorer, each worksheet is titled Sheet1(Sheet1). In the Properties Window, I see two types of names: (Name) and Name, i.e., one enclosed in parenthesis and the other not. What are the differences between these two types of names for the worksheet? I want the user to have the ability to change the worksheet names but not have it affect my code. I tried Index and Item but those refer to the position of the sheet and not it's "name". Michael VBA Beginner -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Names Baffling Problem | Excel Discussion (Misc queries) | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
| Convert Local Names to Global Names | Excel Worksheet Functions | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Hybrid Mode
