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