Posted to microsoft.public.excel.programming

external usenet poster

Posts: 13

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Call VBScript from VBA, pass variable, return result to macro?	Ed	Excel Programming	26	July 11th 06 07:07 PM
Define worksheet as variable, then call in macro	bugman	Excel Programming	2	November 22nd 05 05:13 PM
Call procedure using variable	donbowyer	Excel Programming	2	October 28th 05 09:21 AM
can I call a procedure using a variable	Santiago Gomez	Excel Programming	8	December 24th 03 09:08 PM
Using variable to call worksheets	Calypsoblur	Excel Programming	3	November 8th 03 10:47 PM

All times are GMT +1. The time now is 02:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us