Forum Discussion
Excel Performance Issues and Errors when PC Usage is high
I have been using Excel for over 25+ years and consider myself an expert. Excel cannot handle complex formulas and big data. Even without volatile formulas Excel can't handle much of anything you thr...
is your code modular? See example below and maybe create error handling routine/subroutine/sub procedure
https://docs.microsoft.com/en-us/dotnet/visual-basic/programming-guide/program-structure/main-procedure
Module mainModule
Function Main() As Integer
MsgBox("The Main procedure is starting the application.")
Dim returnValue As Integer = 0
' Insert call to appropriate starting place in your code.
' On return, assign appropriate value to returnValue.
' 0 usually means successful completion.
MsgBox("The application is terminating with error level " &
CStr(returnValue) & ".")
Return returnValue
End Function
End Module
OtherFunction(
Other Function Statements or Expressions...
)
Other Sub(
Other Sub Lines...
Exit Sub
)
The Main Procedure is only required for Console Applications that run on their own. While this workbook contains a Workbook_Open Event it wouldn't qualify based on that. Great idea though.