MrExcel Publishing
Your One Stop for Excel Tips & Solutions

One macro calling another


Posted by Robert Yerby on September 05, 2001 9:43 AM

I must be having a bad day.
Can anybody tell me what the command is for one macro to call another.
Basically I have an Auto-Close macro but there are occassions when I need the macro code to be run without closing the worksheet.
I could just copy the code but I'm sure there must be a better way.
Thanks
Robert


Posted by Dexter on September 05, 2001 9:52 AM

Just list the procedure name (without the () ) in your code