| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names.Add method
Hi all
I'd like to know how to use Names.Add method with MacroType of 2 and what we can do with it. Help cites the following on MacroType parameter of the Add method Value Meaning 1 User-defined function (Function procedure) 2 Macro (also known as Sub procedure) 3 or omitted None (that is, the name doesnt refer to a user-defined function or macro) From my book, I know how to set Name as function but not how to associate it with Macro. I don't see any example of this. Can anyone show me how to do it, please Cheers -- Tetsuya Oguma, Sydney, Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
| Please post this thread a correct full method, method about | New Users to Excel | |||
| Please post this thread a complete correct method, method about te | New Users to Excel | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| Change names of files in a folder to match names in Excel Column | Excel Programming | |||
![Tetsuya Oguma[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
