Thread: call macro with variable
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Whit Whit is offline
external usenet poster
  
Posts: 13
Default call macro with variable
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


Reply With QuoteReply With Quote