View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default Code execution skips Application.Run statement

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?

Regards.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date: 05/03/2004