Code execution skips Application.Run statement

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

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.VlnSearchAndProtect"
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?

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

Application.Run "BofQUtilities.xla!VlnSearchAndProtect"
 
Yes, it was the module name.
I had thought that sequence of code was working ok.
Perhaps it was not.
Irrespective of that, your suggestion appears to be working.
I will test further.

Why might this work rather than a full "path" to the routine,
please?

Regards and thanks.
 
Back
Top