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