Excel help continued

[alrodopial]

Ok, I created a variant (text)
MyVar = "WWW"

I want this text (as variant) to use it as a part of the name of a macro.
So if I want to call the macro "BFWWW" to do it like this:

MyMacro = "BF" & MyVar ' this is equal to MyMacro = "BFWWW"
Call MyMacro ' this is equal to Call BFWWW

but it doesn't recognize the variant MyMacro as the name of the macro "BFWWW"

Any ideas?
Maybe any declare needed?

[alrodopial]

It only needs to change the "call" into "run"
Run MyMacro
works fine.

What is the difference between Call MyMacro and Run MyMacro ?

[osknows]

You normally use the Call statement to call a procedure that does not return a value. If the procedure returns a value, the Call statement discards it.

Run is normally used if the procedure you are calling is held in a variable

You can also call a procedure directly without either statement so below all do the same thing

MyMacro
Call MyMacro
Application.Run MacroName:="MyMacro"