View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Code execution skips Application.Run statement

I'm assuming that InDirect_Menu_Routines is your module name. In that
case, try:

Application.Run "BofQUtilities.xla!VlnSearchAndProtect"

In article ,
"Stuart" wrote:

In the following code sequence:

Set wkbk = ActiveWorkbook
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Call InsertVlnCollectionFormulae(wkbk)
Call TransferToSummarySheet(wkbk)
Application.Run _
"BofQUtilities.xla!InDirect_Menu_Routines.VlnSearc hAndProtect"
Application.Calculation = xlCalculationAutomatic

the Application.Run statement is not executing. When I set
breakpoints, the code stepped straight through the line.

Can anyone help, please?