Get the macro name

**Voicu** · 10-31-2009, 03:55 PM

Hi all,

I have a macro which do something, but I want also this macro to input his name into a cell.
Ex.:

Please Login or Register  to view this content.

I need name "test" into a cell.

**shg** · 10-31-2009, 03:58 PM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

You can't call a Sub from the worksheet, only functions.

**Richard Buttrey** · 10-31-2009, 03:59 PM

Hi,

You don't say which cell, so change A1 below as appropriate.

Please Login or Register  to view this content.

**Voicu** · 10-31-2009, 04:39 PM

Apology for my mistake. In cell A1, I want the name of macro with the same code, indifferent what name has macro.
It is also good for me if in macro I can call a function which return the name of macro.

**Richard Buttrey** · 11-01-2009, 07:37 AM

Hi,

Are you saying that the text in A1 is the name of a macro that you want to run from within another procedure?

If so just use

Please Login or Register  to view this content.

I prefer using the 'Call' instruction since it reminds you that what follows is a procedure name. However it's only necessary if you want to pass parameters to the procedure. You can just use the procedure name if you prefer.

Regards