Hi
didn't test this before. Looks like you simply cannot call a variable
name macro.
I'd suggest you create one macro with a variable parameter

Sub myMacro (i as integer)
'code depending on i
end sub

Then in the loop do
Call myMacro i

regards
Paul
On Apr 2, 10:16*am, Whit wrote:
I get a compile error...



" wrote:
Hi
You don't use brackets.
* * * * Call MacroName

or if it has parameters

* * * * Call MacroName variable1, variable2, etc

regards
Paul

On Apr 2, 10:01 am, Whit wrote:
How can I call a macro when the name is a variable

* * MacroName = "example"
* * While i <= 14
* * * * MacroName = MacroName & i
* * * * Call MacroName (path)
* * * * i = i + 1
* * Loop

Cheers- Hide quoted text -

- Show quoted text -