Forum Discussion
On Excel File Closing - Receive Out of Memory Warning and Closing of Application
I have a reasonably large file with VBA code and Userforms. Frequently, upon closing this file I receive the error "Microsoft Visual Basic for Applications - Out of memory". Once I have closed the er...
Any User Defined FUnctions called from cells in your file?
JKPieterse Thank you for asking this question Jan Karel. I am experiencing the same issue and I do indeed have user defined functions from cells in my file. Specifically:
a generic public function: UserName = ENVIRON("UserName") and another UserAccess = Application.WorksheetFunction.Vlookup(UserName,tblUserRange,2,0).
Could this be a potential source of error?