Need some help with a project

[excelnoobie]

Hey guys i'm trying ot get this macro in which i can call many other macros within it, sort of like a master macro, but i keep getting the problem of expected variable or procedure, when I compile to see any errors. I don't know, this may be due to how extensive all the other macros are. Any help would be appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
Change the names of your modules (or macros), macros & modules should never have the same name, as it can cause confusion & problems.

 

[excelnoobie]

Hi & welcome to MrExcel.
Change the names of your modules (or macros), macros & modules should never have the same name, as it can cause confusion & problems.

Thank you for fast response, i did try to change the name of the modules, so that they were not the same as the actual name of the macros in the VBA code but it did not work sadly. Is there any way i can send you the excel file to see for yourself.

 

[Fluff]

In what way didn't it work?

 

[excelnoobie]

In what way didn't it work?

It gave me the same error of expected variable or procedure, I'm not sure but i think the other macros may just be too extensive in information.

 

[Fluff]

That error suggests you still have a macro with the same name as a module, or you have mistyped the name of one of the macros.