Thread: Call module
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bishop Bishop is offline
external usenet poster
 
Posts: 208
Default Call module

I have 2 modules in a particular Project. Each module is a Sub. I'm trying
to call one module within another module and I'm getting the following error:

Compile Error:
Expected variable or procedure, not module

The two modules a TallySheetRepDump and BanSumSort

This is how I'm trying to call the module:

Sub TallySheetRepDump()
Call BanSumSort
...

I basically want the code inside BanSumSort to run immediately upon the
execution of the TallySheetRepDump routine then continue with the code in
TallySheetRepDump. What am I doing wrong?